Question 1

Which of the following is an example of an external database in the data warehouse model?

Accepted Answer

A)   Marketing information
B)   Sales information
C)   Competitor information
D)   All of theseE) None of the above
F) B) and D)

Question 2

A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse.

Accepted Answer

A) True 
 B)False

Question 3

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

Question 4

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

Accepted Answer

A)   Inaccurate data
B)   Non-integrated data
C)   Violates business rules data
D)   All of theseE) A) and B)
F) C) and D)

Question 5

ETL stands for extraction, transformation, and loading.

Accepted Answer

A) True 
 B)False

Question 6

In a data warehouse, information cleansing occurs first during the ETL process and again once the information is in the data warehouse.

Accepted Answer

A) True 
 B)False

Question 7

The primary purpose of a data warehouse is to perform transactional processes.

Accepted Answer

A) True 
 B)False

Question 8

Identify the advantages of using business intelligence to support managerial decision making.

Accepted Answer

Many organizations today find it next to...

Question 9

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

Question 10

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

Question 11

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

Accepted Answer

A)   Non-formatted data
B)   Misleading data
C)   Incorrect data
D)   All of the choices are correctE) None of the above
F) B) and D)

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Accepted Answer

A)   Does not include information from other operational applications
B)   Operational systems are integrated
C)   Operational information is mainly current
D)   Operational information frequently has quality issuesE) A) and D)
F) A) and B)

Question 17

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 18

While a traditional data warehouse stores data in files or folders, a data lake uses a flat architecture to store data.

Accepted Answer

A) True 
 B)False

Question 19

What is erroneous or flawed data?

Accepted Answer

A)   Dirty data
B)   Information cleansing
C)   Information Scrubbing
D)   ETLE) C) and D)
F) A) and B)

Question 20

Which of the following is not a dirty data problem?

Accepted Answer

A)   Duplicate data.
B)   Inaccurate data.
C)   Specific data.
D)   Non-integrated data.E) B) and D)
F) A) and C)

Exam 7: Accessing Organizational Informationdata Warehouses

Which of the following is an example of an external database in the data warehouse model?

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

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

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

While a traditional data warehouse stores data in files or folders, a data lake uses a flat architecture to store data.

Correct AnswerverifiedShow Answer

Which of the following is not a dirty data problem?

Correct AnswerverifiedShow Answer

A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse.

Correct AnswerverifiedShow Answer

ETL stands for extraction, transformation, and loading.

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is erroneous or flawed data?

Correct AnswerverifiedShow Answer

Identify the advantages of using business intelligence to support managerial decision making.

Correct AnswerverifiedMany organizations today find it next to...View AnswerShow Answer

What is extraction, transformation, and loading?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The primary purpose of a data warehouse is to perform transactional processes.

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

In a data warehouse, information cleansing occurs first during the ETL process and again once the information is in the data warehouse.

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

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
Many organizations today find it next to...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified