Chap 3 Data Warehousing

One way an operational data store differs from a data warehouse is the recency of their data.

• True

• False

Two-tier data warehouse/BI infrastructures offer organizations more exibility but cost more than three-tier ones.

• True

• False

The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts.

• True

• False

Bill Inmon advocates the data mart bus architecture whereas Ralph Kimball promotes the hub-and-spoke architecture

• True

• False

Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse

• centralized data warehouse architecture

• hub-and-spoke data warehouse architecture

• independent data marts architecture

• federated architecture

In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?

• load

• tokenize

• cleanse

• extraction

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

• data mart

• data stores

• metadata

• idk

________ modeling is a retrieval-based system that supports high-volume query access.

• Star

• ETL

• Dimensional

• Enterprise Information Integration