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