Deck 8: Accessing Organizational Information-Data Warehouse

Question 1

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.

Answer 1

C
Explanation: Lands' End chose to build data marts to fix its problem with too much information.

Question 2

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

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.

Answer 2

B
Explanation: Operational systems are not integrated.

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: Business intelligence can provide managers with the ability to make better decisions.

Question 4

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 5

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 6

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 7

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.

Question 8

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 9

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 10

What do data warehouses support?

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

Question 11

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 12

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 13

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 14

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 15

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.

Question 16

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

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 19

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 20

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 21

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

Question 22

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

Question 23

A dimension is a particular attribute of information.

Question 24

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

Question 25

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

Question 26

A data __________ contains a subset of data warehouse information.

Question 27

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 28

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

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

Question 29

What types of BI decisions include predicting sales,determining correct inventory levels,and distribution schedules among outlets,and loss prevention?

A) Retail and sales BI decisions
B) Banking BI decisions
C) Operations management BI decisions
D) Insurance BI decisions

Question 30

What types of BI decisions include forecasting claim amounts and medical coverage costs,classifying the most important elements that affect medical coverage; predicting which customers will buy new insurance policies?

A) Retail and sales BI decisions
B) Banking BI decisions
C) Operations management BI decisions
D) Insurance BI decisions

Question 31

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

Question 32

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

Question 33

Which of the following is not one of the parallels between challenges in business and those of war?

A) Collecting information
B) Using tactical business intelligence
C) Discerning patterns and meaning in the information
D) Responding to the resultant information

Question 34

What types of BI decisions include forecasting levels of bad loans and fraudulent credit card use,credit card spending by new customers,and which kinds of customers will best respond to new loan offers?

A) Retail and sales BI decisions
B) Banking BI decisions
C) Operations management BI decisions
D) Insurance BI decisions

Question 35

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

Question 36

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

Question 37

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

Question 38

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

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

Question 39

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 40

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

Question 41

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

Question 42

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

Question 43

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

Question 44

Explain the relationship between business intelligence and a data warehouse.

Question 45

Explain the problem associated with business intelligence.Describe the solution to this business problem.

Question 46

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