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
Correct Answer:

Verified
Correct Answer:
Verified
Q17: A snowflake design is a feature of
Q18: Data in a typical data warehouse _.<br>A)
Q19: Adding data acquired from outside of the
Q20: All of the following are desirable types
Q21: Data warehouse data is characterized as subject
Q23: One type of data cleaning is to
Q24: Interchanging the data dimensions is known as
Q25: A star schema has a "fact table,"
Q26: Data transformation takes place after the data
Q27: The process of adding externally acquired data