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 denormalized
D)Both B and C are correct

Question

Quizplus · Accepted Answer

A data warehouse database often contains denormalized data, which means that data is duplicated and repeated across tables to improve query performance. Operational databases typically use normalized data to ensure data consistency and reduce data redundancy. Additionally, although data warehouses do have metadata, this is not a defining difference between them and operational databases.

A Data Warehouse Database Differs from an Operational Database Because