100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
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 $7.99   Add to cart

Exam (elaborations)

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

 14 views  0 purchase
  • Course
  • Institution

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

[Show more]

Preview 3 out of 17  pages

  • July 28, 2024
  • 17
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers
avatar-seller
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.

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller AcademicSuperScores. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $7.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

67866 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling

Recently viewed by you


$7.99
  • (0)
  Add to cart