Business Intelligence, Analytics, Data Science, and AI, 5th Edition by Ramesh Sharda, Dursun Delen, Efraim Turban Chapter 4 Descriptive Analytics II: Business Intelligence Data Warehousing, and Visualization

Business Intelligence, Analytics, Data Science,
and AI, 5th Edition by Ramesh Sharda, Dursun
Delen, Efraim Turban
Chapter 4 Descriptive Analytics II: Business Intelligence Data Warehousing, and
Visualization

1) Business intelligence systems rely on a data warehouse as the information source for creating
insight and supporting managerial decisions.
Answer: TRUE
Diff: 1 Page Ref: 219

2) The "islands of data" problem in the 1980s describes the phenomenon of fully integrated data
being stored in a central location within an organization.
Answer: FALSE
Diff: 1 Page Ref: 221

3) Subject oriented databases for data warehousing are organized by detailed subjects such as
disk drives, computers, and networks.
Answer: FALSE
Diff: 2 Page Ref: 223

4) Data warehouses are subsets of data marts.
Answer: FALSE
Diff: 1 Page Ref: 224

5) One way an operational data store differs from a data warehouse is the recency of their data.
Answer: TRUE
Diff: 2 Page Ref: 224

6) Organizations seldom devote a lot of effort to creating metadata because it is not important for
the effective use of data warehouses.
Answer: FALSE
Diff: 1 Page Ref: 225

7) Without middleware, different BI programs cannot easily connect to the data warehouse.
Answer: TRUE
Diff: 2 Page Ref: 226

8) Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more
than three-tier ones.
Answer: FALSE
Diff: 2 Page Ref: 227

1
Copyright © 2024 Pearson Education Ltd.

,9) Moving the data into a data warehouse is usually the easiest part of creating and sustaining a
data warehousing system.
Answer: FALSE
Diff: 2 Page Ref: 229




2
Copyright © 2024 Pearson Education Ltd.

, 10) The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent
data marts.
Answer: TRUE
Diff: 2 Page Ref: 231

11) Because of performance and data quality issues, most experts agree that the federated
architecture should supplement data warehouses, not replace them.
Answer: TRUE
Diff: 2 Page Ref: 231

12) Bill Inmon advocates the data mart bus architecture whereas Ralph Kimball promotes the
hub-and-spoke architecture, a data mart bus architecture with conformed dimensions.
Answer: FALSE
Diff: 2 Page Ref: 232

13) Properly integrating data from various databases and other disparate sources is not a trivial
process.
Answer: TRUE
Diff: 1 Page Ref: 241

14) Enterprise information integration is an evolving tool space that promises real-time data
integration from a variety of sources, such as relational databases, Web services, and
multidimensional databases.
Answer: TRUE
Diff: 2 Page Ref: 243

15) A report is any communication artifact prepared with the specific intention of conveying
information in a digestible form to whoever needs it, whenever and wherever they may need it.
Answer: TRUE
Diff: 1 Page Ref: 252

16) OLTP systems are designed to handle ad hoc analysis and complex queries that deal with
many data items.
Answer: FALSE
Diff: 2 Page Ref: 239

17) The snowflake schema is a logical arrangement of tables in a multidimensional database in
such a way that the entity-relationship diagram resembles a star in shape.
Answer: FALSE
Diff: 2 Page Ref: 238

18) User-initiated navigation of data through disaggregation is referred to as "drill up."
Answer: FALSE
Diff: 3 Page Ref: 240




3
Copyright © 2024 Pearson Education Ltd.