Question 1 What
is information that people use to support their decision-making efforts?
Data mining
Business
intelligence
Information cleansing and scrubbing
Data-mining tools
Question 2 Why
would a business use a data warehouse that offers strategic level, external,
integrated, and historical information?
Identify trends
Make projections
Decide key business issues
All of
the above
Question 3 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?
Accessibility versus completeness
Accessibility versus complexity
Accuracy versus complexity
Accuracy
versus completeness
Question 4 When
does information cleansing occur in the data warehouse?
During the ETL process
During
the ETL process and once it is in the data warehouse
During the ETL process and before it is in the data
warehouse
On the information, once it is in the data warehouse
Question 5 Which
of the following does not draw a parallel between the challenges in business
and the challenges of war?
Discerning patterns and meaning in the information
Responding to the resultant information
Collecting information
Accurate
and complete information
Question 6 Information
cleansing or scrubbing is the process that weeds out and fixes or discards
inconsistent, incorrect, or incomplete information.
True
False
Question 7 Business
intelligence (BI) refers to applications and technologies that are used to
gather, provide access to, and analyze data and information to support
decision-making efforts.
True
False
Question 8 The
primary purpose of a data warehouse is to perform transactional processes.
True
False
Question 9 The
Data Warehousing Institute estimates that low-quality information costs U.S.
businesses $60 billion annually.
True
False
Question 10 What is
the primary purpose of a data warehouse?
To disaggregate information throughout an organization into
multiple repositories in such a way that employees can make decisions and
undertake business analysis activities.
To aggregate information throughout an organization into a
single repository in such a way that employees can make decisions and undertake
business analysis activities.
To disaggregate information throughout an organization into
a single repository in such a way that employees can make decisions and undertake
business analysis activities.
To aggregate information throughout an organization into
multiple repositories in such a way that employees can make decisions and
undertake business analysis activities.
Question 11 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.
True
False
Question 12 A relational
database contains information in a series of two-dimensional tables. How is
data contained in a data warehouse and data mart?
Information
is multidimensional, meaning it contains layers of columns and rows.
Information is multidimensional, meaning it contains a
single layer data in a table format.
Information is two-dimensional, meaning it contains a single
layer data in a table format.
Information is two-dimensional, meaning it contains layers
of columns and rows.
Question 13 What is
data mining?
The
process of analyzing data to extract information not offered by the raw data
alone
The common term for the representation of multidimensional
information
A particular attribute of information
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
Question 14 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?
Table
Block
Cube
All of the above
Question 15 Which
of the following is one of the principle BI enablers?
Technology, processes, and customer culture
Technology, people, and customer culture
Technology, processes, and corporate culture
Technology,
people, and corporate culture
Question 16 Which
of the following describes ETL?
A process that transforms information using a common set of
enterprise definitions
A process that loads information into a data warehouse
A process that extracts information from internal and
external databases
All of
the above
Question 17 A cube
is the common term for the representation of multidimensional information.
True
False
Question 18 Which
of the following is not one of the principal BI enablers?
Corporate
processes
Corporate culture
People
Technology
Question 19 All of
the following are reasons why operational systems are not appropriate for
business analysis, except:
Does not include information from other operational applications
Operational information is mainly current
Operational
systems are integrated
Operational information frequently has quality issues
Question 20 Which
of the following statements is true?
The
more complete and accurate an organization wants to get its information, the
more it costs
The more accurate an organization wants to get its
information, the less it costs
The less accurate an organization wants to get its
information, the more it costs
The more complete an organization wants to get its
information, the less it costs
Question 21 A data
mart is a company that collects and sells external data for a data warehouse.
True
False
Question 22 A
dimension is a particular attribute of information.
True
False
Question 23 The
data warehouse is a location for all of a business's information.
True
False
Question 24 Which
of the following statements is true regarding customer information?
Customer information can exist in several operational
systems
Customer information in each operational system could change
Customer information in each operational system can be
different
All of
the above
Question 25 What
does the Data Warehousing Institute estimate that low-quality information costs
U.S. businesses annually?
$600
billion
$6 billion
$5 million
$6 trillion
Question 26 A data
warehouse is a _________ collection of information-gathered from many different
___________ databases-that supports business analysis activities and
decision-making tasks.
Logical,
operational
Physical, transactional
Physical, operational
Logical, transactional
Question 27 With
careful planning, 100% complete and accurate information is possible.
True
False
Question 28 Which
of the following occurs during data cleansing?
Clean inconsistent information
Clean incorrect information
Clean incomplete information
All of
the above
Question 29 What is
a dimension?
A particular relational database.
A particular single repository.
A
particular attribute of information.
A particular entity of information.
Question 30 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 solution?
Build a better, more efficient data warehouse
Build a data-driven website
Build a better, more efficient transactional database
Build a
data mart
Question 31 Match
the following terms with their definition.
1. Data
warehouse - A logical collection of information, gathered from many different
operational databases, that supports business analysis activities and
decision-making tasks
2. Data mining -
The process of analyzing data to extract information not offered by the raw
data alone
3. ETL- A
process that extracts information from internal and external databases,
transforms the information, and loads the information into a data warehouse
4. Business
intelligence - Refers to applications and technologies that are used to gather,
provide access to, and analyze data and information to support decision-making
efforts
5. Information
cleansing or scrubbing - A process that weeds out and fixes or discards
inconsistent, incorrect, or incomplete information
