CIS CH7 MULTIPLE CHOICE
Which of the following is a problem associated with dirty data? A Accurate data B Integrated data C Violates business rules D All of these
Violates business rules
Business analysis is difficult from operational databases Which of the following is not a reason why? A Every department has its own method for recording data B When sharing data, the data matches with the data warehouse and users get the data they need C The data is of poor quality D The data collected is not always useful for intended purposes
When sharing data, the data matches with the data warehouse and users get the data they need
Which of the following is a problem associated with dirty data? A Duplicate data B Incorrect data C Violates business rules D All of these
All of these
Why were data warehouses created? A. Numbers and types of operational databases increased as businesses grew. B. Many companies had information scattered across multiple systems with different formats. C. Completing reporting requests from numerous operational systems took days or weeks. D. All of these.
All of these
How would the law enforcement industry use business intelligence? A Track crime patterns, locations, and criminal behavior B Analyze customer demographics C Predict sales, inventory levels, and distribution D Predict hardware failures
Track crime patterns, locations, and criminal behavior
Business intelligence can provide managers with the ability to make better decisions Which of the following is not an example of how different industries use business intelligence? A Analyze popular vacation locations with current flight listings B Understand customer credit card usage and nonpayment rates C Compare the demographics of patients with critical illnesses D All of these are examples of how industries use business intelligence
All of these are examples of how industries use business intelligence
What is data-driven decision management? A A business that collects personal information about consumers and sells that information to other organizations B A storage repository that holds a vast amount of raw data in its original format until the business needs it C A technique for establishing a match, or balance, between the source data and the target data warehouse D An approach to business governance that values decisions that can be backed up with verifiable data
An approach to business governance that values decisions that can be backed up with verifiable data
Which of the following statements is true? A The more complete an organization wants its information to be, the less it costs B The more accurate an organization wants its information to be, the less it costs C The less accurate an organization wants its information to be, the more it costs D The more complete and accurate an organization wants its information to be, the more it costs
The more complete and accurate an organization wants its information to be, the more it costs
What is information that people use to support their decision-making efforts? A Information cleansing and scrubbing B Data-mining tools C Data mining D Business intelligence
Business intelligence
Which of the following statements is true regarding customer information? A. Customer information can exist in several operational systems. B. Customer information in each operational system could change. C. Customer information in each operational system can be different. D. All of these.
All of these
BI can help managers with ___________, where a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products A Comparative analysis B Competitive monitoring C Data-driven decision management D Source data
Competitive monitoring
Which of the following is an example of an external database in the data warehouse model? A. Marketing information B. Sales information C. Competitor information D. All of these
Competitor information
Which of the following is the common term for the representation of multidimensional information? A Block B Square C Column D Cube
Cube
How would the banking industry use business intelligence? A Analyze popular vacation locations with current flight listings B Understand customer credit card usage and nonpayment rates C Compare the demographics of patients with critical illnesses D Predict claim amounts and medical coverage costs
Understand customer credit card usage and nonpayment rates
What is a data lake? A A business that collects personal information about consumers and sells that information to other organizations B A storage repository that holds a vast amount of raw data in its original format until the business needs it C A technique for establishing a match, or balance, between the source data and the target data warehouse D An approach to business governance that values decisions that can be backed up with verifiable data
storage repository that holds a vast amount of raw data in its original format until the business needs it
What is a data map? A A business that collects personal information about consumers and sells that information to other organizations B A storage repository that holds a vast amount of raw data in its original format until the business needs it C A technique for establishing a match, or balance, between the source data and the target data warehouse D An approach to business governance that values decisions that can be backed up with verifiable data
technique for establishing a match, or balance, between the source data and the target data warehouse
A data warehouse is a _________ collection of information, gathered from many different ___________ databases, that supports business analysis activities and decision-making tasks. A. Logical, operational B. Physical, operational C. Logical, transactional D. Physical, transactional
Logical, operational
What is erroneous or flawed data? A Dirty data B Information cleansing C Information Scrubbing D ETL
Dirty data
Which of the following is a problem associated with dirty data? A Duplicate data B Correct data C Accurate data D All of these
Duplicate data
What is a data broker? A A business that collects personal information about consumers and sells that information to other organizations B A storage repository that holds a vast amount of raw data in its original format until the business needs it C A technique for establishing a match, or balance, between the source data and the target data warehouse D An approach to business governance that values decisions that can be backed up with verifiable data
A business that collects personal information about consumers and sells that information to other organizations
What is a data point? A Identifies the primary location where data is collected B An individual item on a graph or chart C A technique for establishing a match, or balance, between the source data and the target data warehouse D An approach to business governance that values decisions that can be backed up with verifiable data
An individual item on a graph or chart
How would the marketing industry use business intelligence? A Track crime patterns, locations, and criminal behavior B Analyze customer demographics C Predict sales, inventory levels, and distribution D Predict hardware failures
Analyze customer demographics
How would the airline industry use business intelligence? A Analyze popular vacation locations with current flight listings B Understand customer credit card usage and nonpayment rates C Compare the demographics of patients with critical illnesses D Predict claim amounts and medical coverage costs
Analyze popular vacation locations with current flight listings
What is an individual item on a graph or a chart? A Data set B Dirty data C Data map D Data point
Data Point
What is a collection of data from various sources for the purpose of data processing? A Repository B Data warehouse C Data aggregation D Data broker
Data aggregation
What is a business that collects personal information about consumers and sells that information to other organizations? A Repository B Data warehouse C Data aggregation D Data broker
Data broker
What is a storage repository that holds a vast amount of raw data in its original format until the business needs it? A Data broker B Data lake C Data map D Data point
Data lake
What determines the accuracy and completeness of organizational data? A Data quantity audit B Data quality audit C Data intelligence audit D Data accuracy audit
Data quality audit
What is it called when a manager has too much data and information to make a decision? A Data rich, information poor B Data rich, content poor C Data rich, communication poor D Data rich, intelligence
Data rich, information poor
What is an organized collection of data? A Data set B Dirty data C Data map D Data point
Data set
What are the primary differences between a data warehouse and a data mart? A Data warehouses make quick decisions, data marts make slow decisions B Data warehouse tackle ethical issues, data marts tackle hypothetical issues C Data warehouses have a more organization wide focus, data marts have functional focus D Data warehouses have a physical focus, data marts have logical focus
Data warehouses have a more organization wide focus, data marts have functional focus
Which of the following is an approach to business governance that values decisions that can be backed up with verifiable data? A Comparative analysis B Competitive monitoring C Data-driven decision management D Source data
Data-driven decision management
Which of the following is not an information cleansing activity? A Identifies redundant records B Identifies inaccurate or incomplete data C Identifies missing records or attributes D Identifies sales trends
Identifies missing records or attributes
What is source data? A Identifies the primary location where data is collected B A storage repository that holds a vast amount of raw data in its original format until the business needs it C A technique for establishing a match, or balance, between the source data and the target data warehouse D An approach to business governance that values decisions that can be backed up with verifiable data
Identifies the primary location where data is collected
Business intelligence can provide managers with the ability to make better decisions Which of the following is not an example of how different industries use business intelligence? A Predict claim amounts and medical coverage costs B Track crime patterns, locations, and criminal behavior C Identify the primary locations where data is collected D Predict sales, inventory levels, and distribution
Identify the primary locations where data is collected
What is another term for information cleansing? A Information mining B Information scrubbing C Information scrapping D Information marts
Information scrubbing
What is extraction, transformation, and loading? A. It is a process of entering data, tracking data, and loading it into a database B. It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse C. It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube D. It is a process that is performed at the beginning of the data mining model
It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse
Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases? A Marketing, sales, inventory, and billing B Data mart 1, data mart 2, data mart 3 C Competitor and industry information, mailing lists, and stock market analysis D Marketing information, and stock market analysis numbers
Marketing, sales, inventory, and billing
Which of the following is a problem associated with dirty data? A Formatted data B Misleading data C Correct data D All of these
Misleading data
What do data warehouses support? A. OLAP B. Analytical processing C. OLTP D. OLAP and analytical processing
OLAP and analytical processing
How would the insurance industry use business intelligence? A Analyze popular vacation locations with current flight listings B Understand customer credit card usage and nonpayment rates C Compare the demographics of patients with critical illnesses D Predict claim amounts and medical coverage costs
Predict claim amounts and medical coverage costs
How would the technology industry use business intelligence? A Track crime patterns, locations, and criminal behavior B Analyze customer demographics C Predict sales, inventory levels, and distribution D Predict hardware failures
Predict hardware failures
How would the retail industry use business intelligence? A Track crime patterns, locations, and criminal behavior B Analyze customer demographics C Predict sales, inventory levels, and distribution D Predict hardware failures
Predict sales, inventory levels, and distribution
What is a central location in which data is stored and managed? A Repository B Data warehouse C Data aggregation D Data broker
Repository
In which ways does a data warehouse enable business users to be more effective? A Analyzing trends B Identifying financial issues C Understanding competitors D All of these
All of these
What does standardization of data elements accomplish? A Greater accuracy B Completeness and completeness C Increases the quality of information D All of these
All of these
Which of the following describes ETL? A. A process that extracts information from internal and external databases. B. A process that transforms information using a common set of enterprise definitions. C. A process that loads information into a data warehouse. D. All of these.
All of these
Which of the following is a problem associated with dirty data? A Inaccurate data B Misleading data C Non formatted data D All of these
All of these
Which of the following is a problem associated with dirty data? A Inaccurate data B Nonintegrated data C Violates business rules D All of these
All of these
Which of the following is a problem associated with dirty data? A Non formatted data B Misleading data C Incorrect data D All of these
All of these
Which of the following occurs during data cleansing? A Clean missing records B Clean redundant records C Clean inaccurate data D All of these
All of these
Which of the following questions can be answered using business intelligence? A Where has the business been? B Where is the business now? C Where is the business going? D All of these
All of these
Which of the following questions is an example of how managers can use BI to answer tough business questions? A Where has the business been? B Where is the business now? C Where is the business going? D All of these
All of these
Which of the following occurs during data cleansing? A Clean data marts B Clean redundant customer data C Clean accurate data D Clean correct data
Clean redundant customer data
The primary purpose of a data warehouse is to _____________. A. Combine strategic information B. Organize departments C. Interface between the computer and employees D. All of these
Combine strategic information
__________ can compare two or more data sets to identify patterns and trends A Comparative analysis B Competitive monitoring C Data-driven decision management D Competitive analysis
Comparative analysis
How would the health care industry use business intelligence? A Analyze popular vacation locations with current flight listings B Understand customer credit card usage and nonpayment rates C Compare the demographics of patients with critical illnesses D Predict claim amounts and medical coverage costs
Compare the demographics of patients with critical illnesses
What is a technique for establishing a match, or balance, between the source data and the target data warehouse? A Data set B Dirty data C Data map D Data point
Data map
Which of the following contains a subset of data warehouse information? A. Data miner B. Data mart C. Data pool D. Data analyzing tool
Data mart
What is the ultimate outcome of a data warehouse? A. Data goals B. Data relationships C. Data marketing D. Data marts
Data marts
Business analysis is difficult to achieve from operational databases Which of the following is not a reason why? A Inconsistent data definitions B Lack of data standards C Effective direct data access D Poor data quality
Effective direct data access
Business analysis is difficult from operational databases Which of the following is not a reason why? A Every department has its own method for recording data B Data stored in operational databases did not allow users direct access C The data is standardized D The data collected is not always useful for intended purposes
The data is standardized
Which of the following identifies the primary location where data is collected? A Comparative analysis B Competitive monitoring C Data-driven decision management D Source data
Source data
Which of the following is not a dirty data problem? A Duplicate data B Inaccurate data C Specific data D Nonintegrated data
Specific data
Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse. Ensuring gender is referenced the same way is an example of ___________. A. Information scaling B. Streamlining data points C. Standardizing information D. Standardizing protocols
Standardizing information
