Chapter 09 - CHAPTER 9 BUSINESS INTELLIGENCE AND BIG DATA...

CHAPTER 9 — BUSINESS INTELLIGENCE AND BIG DATA
MULTIPLE CHOICE
1. _____ includes a wide range of applications, practices, and technologies for the extraction,
transformation, integration, analysis, interpretation, and presentation of data to support improved
decision making.
a. Business intelligence
b. Artificial intelligence
c. Prescriptive analytics
d. Artificial analytics
ANS: A
RATIONALE: Business intelligence (BI) includes a wide range of applications, practices, and technologies
for the extraction, transformation, integration, analysis, interpretation, and presentation of data to
support improved decision making. The data used in BI is often pulled from multiple sources and may be
internally or externally generated.
2. _____ tools frequently operate on data stored in a data warehouse or data mart. 3. A _____ is a database that stores large amounts of historical data in a form that readily supports
analysis and management decision making in an organization.
4. A(n) _____ is used to pull data from disparate data sources to populate and maintain a data
warehouse.

c. online analytical process
d. drill-down process
ANS: A
RATIONALE: An extract-transform-load (ETL) process is used to pull data from disparate data sources to
populate and maintain a data warehouse. An effective ETL process is essential to ensure data warehouse
success.
5. Which of the following best describes an extract-transform-load (ETL) process?
a. It is a smaller version of a data warehouse—scaled down to meet the specific needs of a business unit.
b. It contains data collections that are enormous and complex.
c. It is a simple but highly useful way to organize structured data into collections of two-dimensional
tables.
d. It is used to pull data from disparate data sources to populate and maintain the data warehouse.
ANS: D
RATIONALE: An extract-transform-load (ETL) process is used to pull data from disparate data sources to
populate and maintain the data warehouse. An effective ETL process is essential to ensure data
warehouse success.