Which statements about data warehousing is not correct?
A) The data warehouse should be separate from the operational system.
B) Data cleansing is a process of transforming data into standard form.
C) Drill-down is a data-mining tool available to users of OLAP.
D) Normalization is an requirement of databases included in a data warehouse.

Question

Quizplus · Accepted Answer

Normalization is not a requirement for databases included in a data warehouse. In fact, denormalization is often used in data warehousing to improve performance and simplify querying. The other statements are all correct: keeping the data warehouse separate from the operational system ensures that reporting and analysis activities do not impact the performance of day-to-day operations; data cleansing involves transforming data into a consistent and usable format; and OLAP tools often include drill-down functionality to explore data at different levels of granularity.

Which Statements About Data Warehousing Is Not Correct