Question 1

What is a technique for establishing a match, or balance, between the source data and the target data warehouse?

Accepted Answer

A)   Data set
B)   Dirty data
C)   Data map
D)   Data pointE) None of the above
F) A) and B)

Question 2

What is erroneous or flawed data?

Accepted Answer

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

Question 3

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

Accepted Answer

A)   Every department has its own method for recording data.
B)   Data standards do not apply across departments.
C)   The data, if available, were often incorrect or incomplete.
D)   All of these.E) A) and D)
F) A) and B)

Question 4

Which of the following statements is true?

Accepted Answer

A)   The more complete an organization wants to get its information, the less it costs
B)   The more accurate an organization wants to get its information, the less it costs
C)   The less accurate an organization wants to get its information, the more it costs
D)   The more complete and accurate an organization wants to get its information, the more it costsE) B) and D)
F) B) and C)

Question 5

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 6

Dirty data is erroneous or flawed data.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

A comparative analysis can compare two or more data sets to identify patterns and trends.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

________ can compare two or more data sets to identify patterns and trends.

Accepted Answer

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

Question 11

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

Accepted Answer

A) True 
 B)False

Question 12

What is a data map?

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

Question 13

One example of a data aggregation is to gather information about particular groups based on specific variables such as age, profession, or income.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is not an information cleansing activity?

Accepted Answer

A)   Identifies redundant records
B)   Identifies inaccurate or incomplete data
C)   Identifies missing records or attributes
D)   Identifies sales trendsE) A) and D)
F) B) and D)

Question 15

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

Accepted Answer

A)   Logical, operational
B)   Physical, operational
C)   Logical, transactional
D)   Physical, transactionalE) A) and B)
F) A) and D)

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

What is data-driven decision management?

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

Question 18

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

Accepted Answer

A)   Data broker
B)   Data lake
C)   Data map
D)   Data pointE) A) and B)
F) A) and C)

Question 19

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

Question 20

Competitive monitoring can compare two or more data sets to identify patterns and trends.

Accepted Answer

A) True 
 B)False

Exam 7: Accessing Organizational Informationdata Warehouses

What is erroneous or flawed 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

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

Correct AnswerverifiedShow Answer

What is a data map?

Correct AnswerverifiedShow Answer

Which of the following is not an information cleansing activity?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Competitive monitoring can compare two or more data sets to identify patterns and trends.

Correct AnswerverifiedShow Answer

Dirty data is erroneous or flawed data.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

Correct AnswerverifiedShow Answer

Which of the following statements is true?

Correct AnswerverifiedShow Answer

________ can compare two or more data sets to identify patterns and trends.

Correct AnswerverifiedShow Answer

One example of a data aggregation is to gather information about particular groups based on specific variables such as age, profession, or income.

Correct AnswerverifiedShow Answer

A comparative analysis can compare two or more data sets to identify patterns and trends.

Correct AnswerverifiedShow Answer

What is data-driven decision management?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is a technique for establishing a match, or balance, between the source data and the target data warehouse?

Correct AnswerverifiedShow Answer

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

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

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

Correct Answer
verified