Question 1

How would the health care industry use business intelligence?

Accepted Answer

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. 
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.

Question 2

Which of the following is incorrect in terms of data warehousing and business intelligence?

Accepted Answer

A) Information from other operational applications is not included. 
B) Operational systems are integrated. 
C) Operational information is mainly current. 
D) Operational information frequently has quality issues. 
A) Information from other operational applications is not included. 
B) Operational systems are integrated. 
C) Operational information is mainly current. 
D) Operational information frequently has quality issues.

Question 3

What are the primary differences between a data warehouse and a data mart?

Accepted Answer

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. 
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.

Question 4

Which of the following are examples of external databases in the data warehouse model?

Accepted Answer

A) Marketing, sales, inventory, and billing. 
B) Data mart 1, data mart 2, and data mart 3. 
C) Competitor and industry information, mailing lists, and stock market analysis. 
D) Marketing information, sales information, and stock market analysis. 
A) Marketing, sales, inventory, and billing. 
B) Data mart 1, data mart 2, and data mart 3. 
C) Competitor and industry information, mailing lists, and stock market analysis. 
D) Marketing information, sales information, and stock market analysis.

Question 5

Business analysis is difficult from operational databases.Which of the following is not a reason why?

Accepted Answer

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. 
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.

Question 6

Business analysis is difficult from operational databases.Which of the following is not a reason why?

Accepted Answer

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. 
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.

Question 7

The complete removal of dirty data from a source is practical and possible.

Accepted Answer

A) True 
 B)False

Question 8

Effective data-driven decision management is reliant upon the quality of the data gathered and the effectiveness of its analysis and interpretation.

Accepted Answer

A) True 
 B)False

Question 9

Business intelligence is an approach to business governance that values decisions that can be backed up with verifiable data.

Accepted Answer

A) True 
 B)False

Question 10

A data miner contains a subset of data warehouse information.

Accepted Answer

A) True 
 B)False

Question 11

Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.

Accepted Answer

A) True 
 B)False

Question 12

What is a data point?

Accepted Answer

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. 
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.

Question 13

Businesses collect a tremendous amount of _____________ information as part of their routine operations.

Accepted Answer

A) operational 
B) transactional 
C) aggregate 
D) comparative 
A) operational 
B) transactional 
C) aggregate 
D) comparative

Question 14

What is an organized collection of data?

Accepted Answer

A) Data set 
B) Dirty data 
C) Data map 
D) Data point 
A) Data set 
B) Dirty data 
C) Data map 
D) Data point

Question 15

Managers can use BI to answer tough business questions.Which of the following describes the value of knowing where the business is going?

Accepted Answer

A) A historical perspective offers important variables for determining trends and patterns. 
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C) Setting strategic direction is critical for planning and creating solid business strategies. 
D) None of these. 
A) A historical perspective offers important variables for determining trends and patterns. 
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C) Setting strategic direction is critical for planning and creating solid business strategies. 
D) None of these.

Question 16

Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases?

Accepted Answer

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. 
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.

Question 17

A data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

Accepted Answer

A) True 
 B)False

Question 18

Business analysis is difficult to achieve from operational databases.Which of the following is not a reason why?

Accepted Answer

A) Inconsistent data definitions. 
B) Lack of data standards. 
C) Effective direct data access. 
D) Poor data quality. 
A) Inconsistent data definitions. 
B) Lack of data standards. 
C) Effective direct data access. 
D) Poor data quality.

Question 19

The primary purpose of a data warehouse is to perform analytical process.

Accepted Answer

A) True 
 B)False

Question 20

Many firms complete data quality audits to determine the accuracy and completeness of its data.

Accepted Answer

A) True 
 B)False

Exam 7: Accessing Organizational Information Data Warehouses

How would the health care industry use business intelligence?

Which of the following is incorrect in terms of data warehousing and business intelligence?

What are the primary differences between a data warehouse and a data mart?

Which of the following are examples of external databases in the data warehouse model?

Business analysis is difficult from operational databases.Which of the following is not a reason why?

Business analysis is difficult from operational databases.Which of the following is not a reason why?

The complete removal of dirty data from a source is practical and possible.

Effective data-driven decision management is reliant upon the quality of the data gathered and the effectiveness of its analysis and interpretation.

Business intelligence is an approach to business governance that values decisions that can be backed up with verifiable data.

A data miner contains a subset of data warehouse information.

Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.

What is a data point?

Businesses collect a tremendous amount of _____________ information as part of their routine operations.

What is an organized collection of data?

Managers can use BI to answer tough business questions.Which of the following describes the value of knowing where the business is going?

Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases?

A data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

Business analysis is difficult to achieve from operational databases.Which of the following is not a reason why?

The primary purpose of a data warehouse is to perform analytical process.

Many firms complete data quality audits to determine the accuracy and completeness of its data.

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Valuing and Storing Organizational Information Databases

Understanding Big Data and Its Impact on Business

Enabling the Organization Decision Making

Extending the Organization Supply Chain Management

Building a Customer-Centric Organization Customer Relationship Management

Integrating the Organization From End to End Enterprise Resource Planning

Creating Innovative Organizations

E-business

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Developing Software to Streamline Operations

Methodologies for Supporting Agile Organizations

Managing Organizational Projects

B: Extension: A Business Basics

B: Extension: A Business Process

B: Extension: A Hardware and Software Basics

B: Extension: A Mis Infrastructures

B: Extension: A Networks and Telecommunications

B: Extension: A Information Security

B: Extension: A Ethics

B: Extension: A Operations Management

B: Extension: A Sustainable Mis Infrastructures

B: Extension: A Business Intelligence

B: Extension: A Global Information Systems

B: Extension: A Global Trends

Filters