Question 1

What is erroneous or flawed data?

Accepted Answer

A)  Data set.
B)  Dirty data.
C)  Data map.
D)  Data point.E) B) and D)
F) A) and B)

Question 2

What is a collection of data from various sources for the purpose of data processing?

Accepted Answer

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

Question 3

Which of the following is not a dirty data problem?

Accepted Answer

A)  Duplicate data.
B)  Inaccurate data.
C)  Specific data.
D)  Nonintegrated data.E) All of the above
F) None of the above

Question 4

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

Question 5

Which of the following statements is true regarding customer information?

Accepted Answer

A)  Customer information can exist in several operational systems.
B)  Customer information in each operational system could change.
C)  Customer information in each operational system can be different.
D)  All of these.E) A) and B)
F) C) and D)

Question 6

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

Question 7

Duplicate data, inaccurate data, misleading data, and incorrect data are all problems associated with dirty data.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is an approach to business governance that values decisions that can be backed up with verifiable data?

Accepted Answer

A)  Comparative analysis.
B)  Competitive monitoring.
C)  Data-driven decision management.
D)  Source data.E) All of the above
F) A) and B)

Question 9

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Accepted Answer

A) True 
 B)False

Question 10

What do data warehouses support?

Accepted Answer

A)  OLAP
B)  Analytical processing
C)  OLTP
D)  OLAP and analytical processingE) A) and B)
F) A) and C)

Question 11

A data set is an individual item on a graph or chart.

Accepted Answer

A) True 
 B)False

Question 12

Within the data warehouse model, the external databases could include competitor information, industry information, and stock market analysis.

Accepted Answer

A) True 
 B)False

Question 13

A data point is an individual item on a graph or chart.

Accepted Answer

A) True 
 B)False

Question 14

A data broker is an individual item on a graph or a chart.

Accepted Answer

A) True 
 B)False

Question 15

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

Question 16

Data-driven decision management is usually undertaken as a way to gain a competitive advantage.A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had _________ productivity rates and ____________ profits.

Accepted Answer

A)  4% lower, 6% higher
B)  4% higher, 6% lower
C)  4% higher, 6% higher
D)  4% lower, 6% lowerE) A) and B)
F) A) and C)

Question 17

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

Question 18

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

Question 19

Which of the following identifies the primary location where data is collected?

Accepted Answer

A)  Comparative analysis.
B)  Competitive monitoring.
C)  Data-driven decision management.
D)  Source data.E) None of the above
F) All of the above

Question 20

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

Exam 7: Accessing Organizational Information Data Warehouses

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

Correct AnswerverifiedShow Answer

Which of the following is not a dirty data problem?

Correct AnswerverifiedShow Answer

A data point is an individual item on a graph or chart.

Correct AnswerverifiedShow Answer

A data set is an individual item on a graph or chart.

Correct AnswerverifiedShow Answer

How would the airline industry use business intelligence?

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

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

Data-driven decision management is usually undertaken as a way to gain a competitive advantage.A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had _________ productivity rates and ____________ profits.

Correct AnswerverifiedShow Answer

Duplicate data, inaccurate data, misleading data, and incorrect data are all problems associated with dirty data.

Correct AnswerverifiedShow Answer

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Correct AnswerverifiedShow Answer

Which of the following statements is true regarding customer information?

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

A data broker is an individual item on a graph or a chart.

Correct AnswerverifiedShow Answer

Within the data warehouse model, the external databases could include competitor information, industry information, and stock market analysis.

Correct AnswerverifiedShow Answer

Which of the following is an approach to business governance that values decisions that can be backed up with verifiable data?

Correct AnswerverifiedShow Answer

What do data warehouses support?

Correct AnswerverifiedShow Answer

What is a collection of data from various sources for the purpose of data processing?

Correct AnswerverifiedShow Answer

Which of the following identifies the primary location where data is collected?

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

Data-driven decision management is usually undertaken as a way to gain a competitive advantage.A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had _ productivity rates and ____ profits.

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