Question 1

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

Accepted Answer

A)  operational
B)  transactional
C)  aggregate
D)  comparativeE) B) and C)
F) None of the above

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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.E) A) and D)
F) None of the above

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

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.E) All of the above
F) A) and B)

Question 7

A data miner contains a subset of data warehouse information.

Accepted Answer

A) True 
 B)False

Question 8

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.E) A) and B)
F) A) and C)

Question 9

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.E) A) and D)
F) A) and C)

Question 10

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.E) A) and C)
F) B) and C)

Question 11

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.E) None of the above
F) B) and C)

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.E) B) and C)
F) A) and D)

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 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.E) B) and C)
F) B) and D)

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

What is an organized collection of data?

Accepted Answer

A)  Data set
B)  Dirty data
C)  Data map
D)  Data pointE) A) and D)
F) B) and C)

Question 18

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.E) A) and B)
F) All of the above

Question 19

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 20

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.E) A) and B)
F) A) and C)

Exam 7: Accessing Organizational Information Data Warehouses

What is an organized collection of data?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A data miner contains a subset of data warehouse information.

Correct AnswerverifiedShow Answer

What is a data point?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

How would the health care industry use business intelligence?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified