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