Question 1

Which of the following contains a subset of data warehouse information?

Accepted Answer

A)   Data miner
B)   Data mart
C)   Data pool
D)   Data analyzing toolE) B) and C)
F) A) and D)

Question 2

Which of the following describes ETL?

Accepted Answer

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 the choices are correctE) None of the above
F) A) and C)

Question 3

ETL, within a data warehouse model, stands for exit, track, and load.

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

What is an organized collection of data?

Accepted Answer

A)   Data set.
B)   Dirty data.
C)   Data map.
D)   Data point.E) All of the above
F) A) and D)

Question 6

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.

Accepted Answer

A)   Comparative analysis
B)   Competitive monitoring
C)   Data-driven decision management
D)   Source dataE) C) and D)
F) B) and C)

Question 7

A repository is a central location in which data is stored and managed.

Accepted Answer

A) True 
 B)False

Question 8

What determines the accuracy and completeness of organizational data?

Accepted Answer

A)   Data quantity audit
B)   Data quality audit
C)   Data intelligence audit
D)   Data accuracy auditE) None of the above
F) B) and C)

Question 9

Which of the following questions is an example of how managers can use BI to answer tough business questions?

Accepted Answer

A)   Where has the business been?
B)   Where is the business now?
C)   Where is the business going?
D)   All of these.E) A) and B)
F) A) and C)

Question 10

Define a data warehouse and provide a few reasons it can make a manager more effective.

Accepted Answer

A data warehouse is a logical collection...

Question 11

Which of the following is a problem associated with dirty data?

Accepted Answer

A)   Duplicate data
B)   Correct data
C)   Accurate data
D)   All of the choices are correctE) B) and D)
F) B) and C)

Question 12

The financial industry uses business intelligence to predict hardware failures.

Accepted Answer

A) True 
 B)False

Question 13

Which of the below questions can be answered using business intelligence?

Accepted Answer

A)   Where has the business been?
B)   Where is the business now?
C)   Where is the business going?
D)   All of the choices are correct.E) C) and D)
F) All of the above D

Question 14

In which ways does a data warehouse enable business users to be more effective?

Accepted Answer

A)   Analyzing trends
B)   Identifying financial issues
C)   Understanding competitors
D)   All of theseE) B) and C)
F) A) and B)

Question 15

A data lake is a business that collects personal information about consumers and sells that information to other organizations.

Accepted Answer

A) True 
 B)False  False

Question 16

How would the technology industry use business intelligence?

Accepted Answer

A)   Track crime patterns, locations, and criminal behavior
B)   Analyze customer demographics
C)   Predict sales, inventory levels, and distribution
D)   Predict hardware failuresE) B) and C)
F) C) and D)

Question 17

What is information that people use to support their decision-making efforts?

Accepted Answer

A)   Information cleansing and scrubbing
B)   Data-mining tools
C)   Data mining
D)   Business intelligenceE) B) and C)
F) A) and D)

Question 18

How would the banking 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 costsE) A) and B)
F) A) and C)

Question 19

What is a data lake?

Accepted Answer

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 dataE) None of the above
F) C) and D)

Question 20

Source data identifies the primary location where data is collected. It can include invoices, spreadsheets, timesheets, transactions, and electronic sources such as other databases.

Accepted Answer

A) True 
 B)False

Exam 7: Accessing Organizational Informationdata Warehouses

Which of the following contains a subset of data warehouse information?

Correct AnswerverifiedShow Answer

Which of the following describes ETL?

Correct AnswerverifiedShow Answer

ETL, within a data warehouse model, stands for exit, track, and load.

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

What is an organized collection of data?

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

A repository is a central location in which data is stored and managed.

Correct AnswerverifiedShow Answer

What determines the accuracy and completeness of organizational data?

Correct AnswerverifiedShow Answer

Which of the following questions is an example of how managers can use BI to answer tough business questions?

Correct AnswerverifiedShow Answer

Define a data warehouse and provide a few reasons it can make a manager more effective.

Correct AnswerverifiedA data warehouse is a logical collection...View AnswerShow Answer

Which of the following is a problem associated with dirty data?

Correct AnswerverifiedShow Answer

The financial industry uses business intelligence to predict hardware failures.

Correct AnswerverifiedShow Answer

Which of the below questions can be answered using business intelligence?

Correct AnswerverifiedD

In which ways does a data warehouse enable business users to be more effective?

Correct AnswerverifiedShow Answer

A data lake is a business that collects personal information about consumers and sells that information to other organizations.

Correct AnswerverifiedFalse

How would the technology industry use business intelligence?

Correct AnswerverifiedShow Answer

What is information that people use to support their decision-making efforts?

Correct AnswerverifiedShow Answer

How would the banking industry use business intelligence?

Correct AnswerverifiedShow Answer

What is a data lake?

Correct AnswerverifiedShow Answer

Source data identifies the primary location where data is collected. It can include invoices, spreadsheets, timesheets, transactions, and electronic sources such as other databases.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A data warehouse is a logical collection...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified