100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
Previously searched by you
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
Business Intelligence, Analytics, Data Science, An
Business Intelligence, Analytics, Data Science, an
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
Business Intelligence, Analytics, Data Science, an
Institution
Business Intelligence, Analytics, Data Science, An
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...
Business Intelligence, Analytics, Data Science, an
All documents for this subject (12)
Seller
Follow
LIXAN
Reviews received
Content preview
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
,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
, 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
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
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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 LIXAN. 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.
