Data in a typical data warehouse may be denormalized to improve performance because ____.
A) the data does not have necessarily have to be absolutely current
B) data about each of the "subjects" in the data warehouse is typically collected from several of the company's transactional databases
C) data integrity problems are not a concern since the existing data is not updated
D) the data must be of high quality
E) the data may be aggregated

Question

Quizplus · Accepted Answer

Denormalization in a data warehouse is often used to improve query performance, and since the data is not updated frequently, data integrity issues are less of a concern.

Data in a Typical Data Warehouse May Be Denormalized to Improve