Question 1

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)  Duplicate data
B)  Incorrect data
C)  Violates business rules
D)  All of theseE) None of the above
F) B) and C)

Question 3

Companies can choose information cleansing software from several vendors.Which of the following is not a vendor mentioned in your text?

Accepted Answer

A)  Oracle.
B)  SAS.
C)  Ascential Software.
D)  McAffee.E) B) and C)
F) B) and D)

Question 4

What is a data broker?

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

Question 5

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

Question 6

A data lake is a storage repository that holds a vast amount of raw data in its original format until the business needs it.

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

Comparative analysis can help managers with competitive monitoring 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) True 
 B)False

Question 10

Which of the following 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 these.E) All of the above
F) C) and D)

Question 11

What is source data?

Accepted Answer

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

Question 12

What is a central location in which data is stored and managed?

Accepted Answer

A)  Repository
B)  Data warehouse
C)  Data aggregation
D)  Data brokerE) A) and B)
F) A) and C)

Question 13

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?

Accepted Answer

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

Question 14

Why were data warehouses created?

Accepted Answer

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

Question 15

A data mart contains a subset of data warehouse information.

Accepted Answer

A) True 
 B)False

Question 16

What is extraction, transformation, and loading?

Accepted Answer

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 modelE) A) and B)
F) None of the above

Question 17

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

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

Question 18

How would the insurance 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) None of the above
F) A) and D)

Question 19

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

Accepted Answer

A)  Inaccurate data
B)  Misleading data
C)  Non formatted data
D)  All of theseE) C) and D)
F) All of the above

Question 20

Dirty data is erroneous or flawed data.The complete removal of dirty data from a source is impractical or virtually impossible.

Accepted Answer

A) True 
 B)False

Exam 7: Accessing Organizational Information Data Warehouses

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

Correct AnswerverifiedShow Answer

What is source data?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

How would the insurance industry use business intelligence?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is extraction, transformation, and loading?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

What is a data broker?

Correct AnswerverifiedShow Answer

Comparative analysis can help managers with competitive monitoring 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

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

Correct AnswerverifiedShow Answer

Dirty data is erroneous or flawed data.The complete removal of dirty data from a source is impractical or virtually impossible.

Correct AnswerverifiedShow Answer

A data lake is a storage repository that holds a vast amount of raw data in its original format until the business needs it.

Correct AnswerverifiedShow Answer

Companies can choose information cleansing software from several vendors.Which of the following is not a vendor mentioned in your text?

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

What is a central location in which data is stored and managed?

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

A data mart contains a subset of data warehouse information.

Correct AnswerverifiedShow Answer

Why were data warehouses created?

Correct AnswerverifiedShow Answer

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

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
A data warehouse is a logical collection...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified