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) None of the above

Question

Quizplus · Accepted Answer

A data warehouse database differs from an operational database because data warehouse data are often stored in a dimensional database, which uses a different structure than traditional tables used in operational databases. Additionally, data warehouses typically have metadata to help users understand the data and its context, which is not a characteristic of operational databases. Therefore, option C is the correct choice.

A Data Warehouse Database Differs from an Operational Database Because