Question 1

Which of the following does not draw a parallel between the challenges in business and the challenges of war?

Accepted Answer

A)   Collecting information.
B)   Discerning patterns and meaning in the information.
C)   Accurate and complete information.
D)   Responding to the resultant information.

Question 2

What does the Data Warehousing Institute estimate that low-quality information costs U.S.businesses annually?

Accepted Answer

A)   $500 million
B)   $60 billion
C)   $600 billion
D)   It is impossible to determine.

Question 3

Data warehousing is about extending the transformation of data into _________.

Accepted Answer

Information

Question 4

Data information in a data warehouse contains layers of columns and rows,and this is known as __________ databases.

Accepted Answer

The answer of Data information in a data warehouse contains...

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

Question 6

Explain the relationship between business intelligence and a data warehouse.

Accepted Answer

The purpose of a data warehous...

Question 7

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

Accepted Answer

logical

Question 8

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 9

A relational database contains information in a series of two-dimensional tables.How is data contained in a data warehouse and data mart?

Accepted Answer

A)   Information is multidimensional, meaning it contains a single layer of data in a table format.
B)   Information is two-dimensional, meaning it contains a single layer of data in a table format.
C)   Information is two-dimensional, meaning it contains layers of columns and rows.
D)   Information is multidimensional, meaning it contains layers of columns and rows. D

Question 10

Extraction,transformation,and loading is a process that extracts information from internal databases,transforms the information using a common set of enterprise definitions,and loads the information into an external database.

Accepted Answer

A) True 
 B)False

Question 11

A data __________ contains a subset of data warehouse information.

Accepted Answer

The answer of A data __________ contains a subset of...

Question 12

The data warehouse is a location for all of a business's information.

Accepted Answer

A) True 
 B)False

Question 13

Explain why an organization cannot achieve 100 percent accurate and complete information.

Accepted Answer

Achieving perfect information is almost ...

Question 14

Why is Noodles & Company using business intelligence?

Accepted Answer

A)   To improve financial analysis.
B)   To improve corporate processes.
C)   To track store quality.
D)   To change the corporate culture.

Question 15

Which of the following can use BI to make informed decisions?

Accepted Answer

A)   Law enforcement industry
B)   Airline industry
C)   Broadcasting industry
D)   All of these

Question 16

All of the following are reasons why operational systems are not appropriate for business analysis except:

Accepted Answer

A)   Operational systems do not include information from other operational applications.
B)   Operational systems are integrated.
C)   Operational information is mainly current.
D)   Operational information frequently has quality issues.

Question 17

Explain the primary difference between a database and a data warehouse.

Accepted Answer

The primary difference between a databas...

Question 18

What is the primary problem most organizations face today concerning information?

Accepted Answer

A)   Business intelligence rich, information rich
B)   Data poor, information rich
C)   Business intelligence poor, information rich
D)   Data rich, information poor

Question 19

A(n)__________ is a particular attribute of information.

Accepted Answer

The answer of A(n)__________ is a particular attribute of information....

Question 20

What do data warehouses support?

Accepted Answer

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

Exam 8: Accessing Organizational Information-Data Warehouse

Which of the following does not draw a parallel between the challenges in business and the challenges of war?

Correct AnswerverifiedShow Answer

What does the Data Warehousing Institute estimate that low-quality information costs U.S.businesses annually?

Correct AnswerverifiedShow Answer

Data warehousing is about extending the transformation of data into _________.

Correct AnswerverifiedInformation

Data information in a data warehouse contains layers of columns and rows,and this is known as __________ databases.

Correct AnswerverifiedShow Answer

Which of the following statements is true regarding customer information?

Correct AnswerverifiedShow Answer

Explain the relationship between business intelligence and a data warehouse.

Correct AnswerverifiedThe purpose of a data warehous...View AnswerShow Answer

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

Correct Answerverifiedlogical

Which of the following occurs during data cleansing?

Correct AnswerverifiedShow Answer

A relational database contains information in a series of two-dimensional tables.How is data contained in a data warehouse and data mart?

Correct AnswerverifiedD

Extraction,transformation,and loading is a process that extracts information from internal databases,transforms the information using a common set of enterprise definitions,and loads the information into an external database.

Correct AnswerverifiedShow Answer

A data __________ contains a subset of data warehouse information.

Correct AnswerverifiedShow Answer

The data warehouse is a location for all of a business's information.

Correct AnswerverifiedShow Answer

Explain why an organization cannot achieve 100 percent accurate and complete information.

Correct AnswerverifiedAchieving perfect information is almost ...View AnswerShow Answer

Why is Noodles & Company using business intelligence?

Correct AnswerverifiedShow Answer

Which of the following can use BI to make informed decisions?

Correct AnswerverifiedShow Answer

All of the following are reasons why operational systems are not appropriate for business analysis except:

Correct AnswerverifiedShow Answer

Explain the primary difference between a database and a data warehouse.

Correct AnswerverifiedThe primary difference between a databas...View AnswerShow Answer

What is the primary problem most organizations face today concerning information?

Correct AnswerverifiedShow Answer

A(n)__________ is a particular attribute of information.

Correct AnswerverifiedShow Answer

What do data warehouses support?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Information

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The purpose of a data warehous...
View Answer

Correct Answer
verified
logical

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Achieving perfect information is almost ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The primary difference between a databas...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified