Question 1

Which of the following occurs during data cleansing?

Accepted Answer

A)  Clean missing records
B)  Clean redundant records
C)  Clean inaccurate data
D)  All of these

Question 2

Which of the following is the common term for the representation of multidimensional information?

Accepted Answer

A)  Block
B)  Square
C)  Column
D)  Cube

Question 3

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 audit

Question 4

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

Accepted Answer

A)  Formatted data
B)  Misleading data
C)  Correct data
D)  All of these

Question 5

ETL stands for extraction, transformation, and loading.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following occurs during data cleansing?

Accepted Answer

A)  Clean data marts
B)  Clean redundant customer data
C)  Clean accurate data
D)  Clean correct data

Question 7

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 failures.

Question 8

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 these

Question 9

A data set is an organized collection of data.

Accepted Answer

A) True 
 B)False

Question 10

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 11

Gender can be referred to in many ways (Male, Female, M/F, 1/0)  in a data warehouse.Ensuring gender is referenced the same way is an example of ___________.

Accepted Answer

A)  Information scaling
B)  Streamlining data points
C)  Standardizing information
D)  Standardizing protocols

Question 12

What is the ultimate outcome of a data warehouse?

Accepted Answer

A)  Data goals
B)  Data relationships
C)  Data marketing
D)  Data marts

Question 13

__________ 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 analysis

Question 14

Which of the following statements is true?

Accepted Answer

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

Question 15

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 trends.

Question 16

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 these

Question 17

How would the law enforcement 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 failures.

Question 18

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 point

Question 19

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

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.

Question 20

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 data

Exam 7: Accessing Organizational Information Data Warehouses

Which of the following occurs during data cleansing?

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

Which of the following is not an information cleansing activity?

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

What determines the accuracy and completeness of organizational data?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

ETL stands for extraction, transformation, and loading.

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

How would the law enforcement industry use business intelligence?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is the ultimate outcome of a data warehouse?

Correct AnswerverifiedShow Answer

Which of the following statements is true?

Correct AnswerverifiedShow Answer

A data set is an organized collection of data.

Correct AnswerverifiedShow Answer

Which of the following is the common term for the representation of multidimensional information?

Correct AnswerverifiedShow Answer

Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse.Ensuring gender is referenced the same way is an example of ___________.

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 now?

Correct AnswerverifiedShow Answer

How would the technology 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

Which of the following occurs during data cleansing?

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

Correct Answer
verified