BCIS 1405 Exam 3 – Flashcards
Unlock all answers in this set
Unlock answersquestion
Which of the following is a benefit of a solid MIS infrastructure?
answer
Reduces costs Improves productivity Optimizes business operations
question
What is the difference between hardware and software?
answer
Hardware is the physical devices associated with a computer system, where software is the instructions the hardware executes to carry out tasks
question
What is a computer dedicated to providing information in response to requests?
answer
Server
question
John works for Internal Computer Specialists, which focuses on helping small business owners resolve MIS infrastructure issues. John's tasks include cleaning and replacing motherboards, cables, and internal components such as DVDs and hard drives. What does John's role at Internal Computer Specialists focus on fixing?
answer
Hardware
question
Which of the below represents the primary elements in an information MIS infrastructure?
answer
Backup, recovery, disaster recovery, and business continuity planning
question
The __________ MIS infrastructure identifies ways that a company can grow in terms of computing resources while simultaneously becoming less dependent on hardware and energy consumption
answer
Sustainable
question
The information MIS infrastructure supports the day-to-day business operations and plans for ___________.
answer
Security breaches and theft Floods and earthquakes Malicious internet attacks
question
Each year businesses lose time and money because of system crashes and failures. Which of the following offers the best way to protect a system from crashes and failures?
answer
Backup and recovery plans Fault tolerance Failover
question
Which of the following describes the difference between a backup plan and a recovery plan?
answer
Backup is an exact copy of a system's information, where recovery is the ability to get a system up and running in the event of a system crash or failure
question
What occurs when a redundant storage server offers an exact replica of the real-time data, and if the primary server crashes, the users are automatically directed to a secondary server?
answer
Failover
question
What has the ability to recover information or systems in the event of catastrophic disasters?
answer
Disaster Recovery
question
What is the ability to get a system up and running in the event of a system crash or failure that includes restoring the information backup?
answer
Recovery
question
Which of the below offers a low-speed and low-cost backup method?
answer
DVD Thumb Drive External Hard Drive
question
What question below would a company need to answer when first establishing a backup and recovery plan?
answer
ALL of the above
question
Which of the following is an effect a company could experience because of a disaster such as a fire, flood, or hurricane?
answer
Disrupting communications Damaging physical infrastructures Halting transportation
question
Within the sites that support disaster recovery, ___________ is a separate and fully equipped facility where the company can move immediately after a disaster and resume business
answer
Hot Site
question
The optimal disaster recovery plan in terms of cost and time is where on the disaster recovery cost curve?
answer
Where the two cost effects intersect
question
What is a more comprehensive and all-encompassing plan that details how a company recovers and restores critical business operations and systems after a disaster or extended disruption?
answer
Business continuity planning
question
What is an infrastructure built for notifying people in the event of an emergency?
answer
Emergency notification service
question
Which term refers to the varying levels that define what a user can access, view, or perform when operating a system?
answer
Accessibility
question
Enterprise architects require ____________ so they can perform such functions as resetting passwords or deleting accounts.
answer
Administrator access
question
Which term refers to the time frames when the system is operational?
answer
Availiability
question
Which of the following agile MIS infrastructure characteristics refers to how quickly a system can transform to support environmental changes?
answer
maintainability
question
Which of the following agile MIS infrastructure characteristics refers to the ability of an application to operate on different devices or software platforms, such as different operating systems?
answer
portability
question
What does reliability ensure?
answer
The system is functioning correctly and providing accurate information
question
Why is estimating future growth a challenge for most companies?
answer
All of the above: Estimating company growth is challenging because growth can occur in different forms, such as the firm can acquire new customers, new product lines, or new markets.
question
Which of the following describes how well a system can scale up, or adapt to the increased demands or growth?
answer
Scalability
question
What measures how quickly a system performs a process or transaction?
answer
Performance
question
What is usability?
answer
The system is easy to learn and efficient and satisfying to use
question
Apple understood the importance of usability when it designed its ________.
answer
iPod and iTunes system
question
Which of the following reflects Moore's law?
answer
New generations of chips deliver double the processing power as the previous generation
question
What describes the production, management, use, and disposal of technology in a way that minimizes damage to the environment?
answer
Sustainability or green MIS
question
Sustainable MIS is a critical part of ____________ within a company.
answer
Corporate social responsibility
question
What are the three pressures driving sustainable MIS infrastructures?
answer
Increases in electronic waste, energy waste, and carbon emissions
question
What are the ramifications of improper electronic recycling, when analyzing the example of a single desktop computer?
answer
One computer contains more than 700 chemicals that can be toxic to the environment: Just a single computer contains more than 700 chemicals that can be toxic to the environment, such as high levels on the toxins mercury, lead and cadmium. If they end up in the landfill, the toxins can leach into our land, water and air. ALL OF THE ABOVE
question
Currently, what percent of ewaste in the United States is not recycled?
answer
80%
question
Which of the following sustainable infrastructure components is a collection of computers, often geographically dispersed, that are coordinated to solve a common problem?
answer
Grid computing
question
With grid computing a problem is broken into pieces and distributed to many machines, allowing _________ processing than could occur with a single system.
answer
Faster
question
Grid computing takes advantage of the available 75% of unused processing power of a computer and links thousands of individual computers around the world creating a _______ that can process intensive tasks.
answer
Virtual supercomputer
question
DreamWorks Animation Company used which sustainable infrastructure component to complete many of its films including Shrek, Madagascar and Antz?
answer
Grid computing
question
What uses resources and applications hosted remotely on the Internet?
answer
Cloud computing
question
What is a challenge for cloud computing that could cause employee performance to decrease?
answer
Required Internet connectivity
question
What service delivers hardware networking capabilities, including the use of servers, networking, and storage over the cloud using a pay-per-use revenue model?
answer
Infrastructure as a Service (IaaS)
question
The most popular IaaS operation today is Amazon's Elastic Compute Cloud (EC2). The benefits when using Amazon as an IaaS includes ___________.
answer
Customers can load and run their own applications Customers can control their own operating environment Customers can create, run, and stop services as needed
question
Which cloud computing model offers applications on a pay-per-use basis?
answer
Software as a Service
question
What is a Platform as a Service (PaaS)?
answer
Supports the deployment of entire systems including hardware, networking, and applications using pay-per-use revenue model
question
What enables computers to run multiple operating systems and multiple software applications at the same time and creates multiple 'virtual' machines all on a single computing device?
answer
Virtualization
question
What is a facility used to house management information systems and associated components, such as telecommunications and storage systems?
answer
Data center
question
What is a model for enabling ubiquitous, convenient, on-demand network access to a shared pool of configurable computing resources (e.g., networks, servers, storage, applications, and services) that can be rapidly provisioned and released with minimal management effort or service provider interaction?
answer
Cloud computing
question
What means that people with disabilities including visual, auditory, physical, speech, cognitive, and neurological disabilities can use the Web?
answer
Web accessibility
question
Which of the following represents the different information levels?
answer
Individual, department, enterprise
question
Which of the following represents the different information granularities?
answer
Detail, summary, aggregate
question
Which of the following implies that aggregate or summary information is in agreement with detailed information?
answer
Consistency
question
Which of the following implies that information is current with respect to the business requirement?
answer
Timeliness
question
What is it called when each transaction, entity, and event is represented only once in the information?
answer
Uniqueness
question
Which of the following encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks?
answer
Transactional information
question
Which of the following encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks?
answer
Analytical information
question
hich of the following companies used analytical analysis to identify a correlation between storms and the increased sale of Pop-Tarts?
answer
Walmart
question
Which of the following refers to immediate, up-to-date information?
answer
Real-time information
question
Which of the following are examples of transactional information?
answer
Airline ticket, sales receipts, and packing slips
question
Which of the following are examples of analytical information?
answer
Future growth analysis, sales projections, and product statistics
question
Which of the following occurs when the same data element has different values?
answer
Data inconsistency issue
question
Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data?
answer
Data integrity issue
question
Which of the following lists include all of the five characteristics common to high-quality information?
answer
Accuracy, completeness, consistency, timeliness, and uniqueness
question
Which of the following represents a reason for low-quality information?
answer
Online customers intentionally enter inaccurate information to protect the privacy Different systems have different information entry standards and formats Third-party and external information contains inaccuracies and errors
question
What is the overall management of the availability, usability, integrity, and security of company data?
answer
Data governance
question
What maintains information about various types of objects, events, people, and places?
answer
Database
question
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
answer
Entity
question
Why do relational databases use primary keys and foreign keys?
answer
To create logical relationships
question
What is the physical view of information?
answer
Deals with the physical storage of information on a storage device such as a hard disk
question
Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?
answer
Database management system
question
Which of the following asks users to write lines of code to answer questions against a database?
answer
Structured query language
question
What is the primary tool that retrieves information and helps users graphically design the answer to a question?
answer
Query-by-example tool
question
What compiles all of the metadata about the data elements in the data model?
answer
Data dictionary
question
What type of keys do you need to use to create a relational database model?
answer
Primary keys and foreign keys
question
What is a field that uniquely identifies a given record in a table?
answer
Primary key
question
What type of integrity constraint does not allow someone to create an order for a nonexistent customer?
answer
Relational integrity constraint
question
Which of the following focuses on how individual users logically access information to meet their own particular business needs?
answer
Logical view
question
One of the primary goals of a database is to eliminate data redundancy by recording each piece of data in only one place in the database. What does the elimination of data redundancy do for a database?
answer
-Reduces disk space requirements -Makes updating information easier -Improves information quality All of the above
question
What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?
answer
Data-driven website
question
A data warehouse is a _________ collection of information, gathered from many different ___________ databases, that supports business analysis activities and decision-making tasks.
answer
Logical, operational
question
The primary purpose of a data warehouse is to ____________.
answer
Combine strategic information
question
Which of the following describes ETL?
answer
A process that extracts information from internal and external databases A process that transforms information using a common set of enterprise definitions A process that loads information into a data warehouse All of the above
question
Which of the following contains a subset of data warehouse information?
answer
Data mart
question
What are the primary differences between a data warehouse and a data mart?
answer
Data warehouses have a more organization-wide focus, data marts have functional focus
question
What is another term for information cleansing?
answer
Information scrubbing
question
What is the process of analyzing data to extract information not offered by the raw data alone?
answer
Data mining
question
Which of the following uses a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making?
answer
Data-mining tools
question
What analyzes unstructured data to find trends and patterns in words and sentences?
answer
Text mining
question
What is web mining?
answer
Unstructured data associated with websites to identify consumer behavior and website navigation
question
What is the technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?
answer
Cluster analysis
question
What is a common association detection analysis technique where you analyze certain items to detect customers' buying behavior and predict future behavior?
answer
Market basket analysis
question
Which of the following techniques performs such functions as information correlations, distributions, calculations, and variance analysis?
answer
Statistical analysis
question
What is it called when a manager has so much data and information that they cannot make a decision?
answer
Data rich, information poor
question
Which of the below questions can be answered using business intelligence?
answer
Where has the business been? Where is the business now? Where is the business now? Where is the business going? All of the above.
question
What is information that people use to support their decision-making efforts?
answer
Business intelligence
question
What includes fixed data incapable of change in the event of a user action?
answer
Static information
question
What includes data that change based on user actions?
answer
Dynamic information
question
What tracks corporate metrics such as critical success factors and key performance indicators and include advanced capabilities such as interactive controls allowing users to manipulate data for analysis?
answer
Business intelligence dashboards
question
What move beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more?
answer
Data visualization Tools
question
What is a technique for documenting the entities and relationships in a database environment?
answer
Entity-relationship diagram
question
What exists to represent the relationship between two other entities?
answer
Composite entity
question
What kind of attribute would be given for a person who does not have an email address?
answer
Null-valued attribute
question
What is a foreign key?
answer
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
question
What is composed of rows and columns that represent an entity?
answer
Table
question
What is a characteristic of a table?
answer
Field
question
What occurs when two entities can be related to each other in many instances?
answer
Many-to-many relationship
question
What is a statement that defines an aspect of a business?
answer
Business rule
question
Which of the following is a possible business rule?
answer
A customer can purchase many DVDs DVDs can be purchased by many customers A DVD title can have many copies All of the above
question
What kind of attribute would be date of birth?
answer
Stored attribute
question
What kind of attribute would be age?
answer
Derived attribute
question
What kind of attribute can be calculated using the value of another attribute?
answer
Derived attribute
question
Which of the following statements is accurate?
answer
A correct business rule for one organization may not be correct for another organization. Each business rule will have entities and sometimes even attributes. A typical business may have hundreds of business rules. All of the above.
question
What has only a single value of each attribute of an entity?
answer
Single-valued attribute
question
What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity?
answer
One-to-one relationship
question
What expresses the specific number of instances in an entity?
answer
Cardinality
question
What has the potential to contain more than one value for an attribute?
answer
Multi-valued attribute
question
What is a collection of related data elements?
answer
Record
question
What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?
answer
One-to-many relationship
question
What is a primary key?
answer
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
