Data in a Typical Data Warehouse May Be Denormalized to Improve

question 22

Multiple Choice

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

---

Definitions:

Yearly Observations

Refers to data points or measurements that are collected once every year.

Trend

A general direction in which something is developing or changing, observed in data over time.

Annual Time-series

A sequence of data points representing the value of a variable over a series of years.

Sequential Order

The arrangement of objects, events, or values in a specific sequence where the order is significant.