FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Data Warehousing

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

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.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?

A) independent data marts architecture
B) centralized data warehouse architecture
C) hub-and-spoke data warehouse architecture
D) federated architecture

E) A) and C)
F) B) and D)

Correct Answer

verified

D

Question 3

Essay

Review LaterAdd Note

Mention briefly some of the recently popularized concepts and technologies that will play a significant role in defining the future of data warehousing.

The ________ data warehouse architecture involves integrating disparate systems and analytical resources from multiple sources to meet changing needs or business conditions.

Online ________ is a term used for a transaction system that is primarily responsible for capturing and storing data related to day-to-day business functions such as ERP,CRM,SCM,and point of sale.

Without middleware,different BI programs cannot easily connect to the data warehouse.

The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization.

The three main types of data warehouses are data marts,operational ________,and enterprise data warehouses.

Operational or transaction databases are product oriented,handling transactions that update the database.In contrast,data warehouses are

All of the following statements about metadata are true EXCEPT

________ describe the structure and meaning of the data,contributing to their effective use.

OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items.

________ (also called in-database analytics)refers to the integration of the algorithmic extent of data analytics into data warehouse.

Which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information?

Briefly describe four major components of the data warehousing process.

Mehra (2005)indicated that few organizations really understand metadata,and fewer understand how to design and implement a metadata strategy.How would you describe metadata?

What is the definition of a data warehouse (DW)in simple terms?

The "single version of the truth" embodied in a data warehouse such as Capri Casinos' means all of the following EXCEPT

Because the recession has raised interest in low-cost open source software,it is now set to replace traditional enterprise software.

In the Starwood Hotels case,up-to-date data and faster reporting helped hotel managers better manage their occupancy rates.