Deck 8: Accessing Organizational Information Data Warehouse

Question 1

Which of the following describes ETL?

A) A process that extracts information from internal and external databases.
B) A process that transforms information using a common set of enterprise definitions.
C) A process that loads information into a data warehouse.
D) All of these.

Answer 1

D
Explanation: All of these describe ETL.

Question 2

What is the primary purpose of a data warehouse?

A) To aggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.
B) To disaggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.
C) To aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.
D) To disaggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.

Answer 2

C
Explanation: The purpose of a data warehouse is to aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.

Question 3

What is information that people use to support their decision-making efforts?

A) Information cleansing and scrubbing
B) Data-mining tools
C) Data mining
D) Business intelligence

Answer 3

D
Explanation: This is the definition of business intelligence.

Question 4

What do data warehouses support?

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

Question 5

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

A) Physical, transactional
B) Physical, operational
C) Logical, transactional
D) Logical, operational

Question 6

Why is Noodles & Company using business intelligence?

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

Question 7

What is a dimension?

A) A particular attribute of information.
B) A particular entity of information.
C) A particular relational database.
D) A particular single repository.

Question 8

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

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

Question 9

Why is Ben & Jerry's using business intelligence?

A) To improve quality.
B) To create new flavors of ice cream.
C) To improve financials.
D) To manage distribution.

Question 10

Which of the following is not one of the principal BI enablers?

A) Technology
B) Corporate processes
C) People
D) Corporate culture

Question 11

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

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.

Question 12

What is data mining?

A) The common term for the representation of multidimensional information.
B) A particular attribute of information.
C) Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making.
D) Process of analyzing data to extract information not offered by the raw data alone.

Question 13

Which of the following occurs during data cleansing?

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

Question 14

When does information cleansing occur in the data warehouse?

A) During the ETL process.
B) On the information, once it is in the data warehouse.
C) During the ETL process and once it is in the data warehouse.
D) During the ETL process and before it is in the data warehouse.

Question 15

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

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

Question 16

Lands' End created an organization-wide data warehouse so all its employees could access organizational information.Lands' End soon found out that there could be "too much of a good thing." Many of its employees would not use the data warehouse,because it was simply too big,too complicated,and had too much irrelevant information.Lands' End knew there was valuable information in its data warehouse,and it had to find a way for its employees to easily access the information.What was Lands' End's solution?

A) Build a better, more efficient data warehouse.
B) Build a better, more efficient transactional database.
C) Build a data mart.
D) Build a data-driven website.

Question 17

Which of the following statements is true?

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

Question 18

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

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

Question 19

Which of the following statements is true regarding customer information?

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 20

Why would a business use a data warehouse that offers strategic level,external,integrated,and historical information?

A) Identify trends.
B) Make projections.
C) Decide key business issues.
D) All of these.

Question 21

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

Question 22

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

Question 23

Explain the multidimensional nature of data warehouses (and data marts)and the business value gained from multidimensional analysis.

Question 24

A dimension is a particular attribute of information.Each layer in a data warehouse or data mart represents information according to an additional dimension.What is the common term for the representation of multidimensional information?

A) Table
B) Block
C) Cube
D) All of these

Question 25

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

Question 26

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

Question 27

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.

Question 28

A data __________ contains a subset of data warehouse information.

Question 29

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

Question 30

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

Question 31

Which of the following are the principle BI enablers?

A) Technology, processes, and customer culture
B) Technology, people, and customer culture
C) Technology, processes, and corporate culture
D) Technology, people, and corporate culture

Question 32

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

Question 33

Achieving perfect information is almost impossible.The more complete and accurate an organization wants its information to be,the more it costs.Which two variables are used to determine the trade-off for perfect information?

A) Accuracy versus completeness.
B) Accessibility versus completeness.
C) Accuracy versus complexity.
D) Accessibility versus complexity.

Question 34

A dimension is a particular attribute of information.

Question 35

Identify the importance of ensuring the cleanliness of information throughout an organization.

Question 36

A(n)___________ is the common term for the representation of multidimensional information.

Question 37

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

Question 38

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

Question 39

The Data Warehousing Institute estimates that low-quality information costs U.S.businesses $60 billion annually.

Question 40

Data _________ is the process of analyzing data to extract information not offered by the raw data alone.

Question 41

Explain the relationship between business intelligence and a data warehouse.