A data warehouse database differs from an operational database because ________.
A) data warehouse data are not stored in tables
B) data warehouse databases do not have metadata
C) data warehouse data are often stored in a dimensional database
D) both B and C
E) data warehouse databases contain unrelated tables

Question

Quizplus · Accepted Answer

Data warehouse data are often stored in a dimensional database which is optimized for retrieval and analysis rather than transaction processing. This is one of the main differences between a data warehouse database and an operational database, which is optimized for transaction processing. The other options are incorrect - data warehouse data is stored in tables and data warehouse databases do have metadata.

A Data Warehouse Database Differs from an Operational Database Because