Exam 3: Data Warehousing

A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a

The ETL process in data warehousing usually takes up a small portion of the time in a data-centric project.

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

Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?

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

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

Performing extensive ________ to move data to the data warehouse may be a sign of poorly managed data and a fundamental lack of a coherent data management strategy.

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

Because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them.

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