Which statement best describes the data stored in a data warehouse?

Which statement best describes the data stored in a data warehouse?

• A. It contains analytically useful information
• B. It stores only metadata about data sources
• C. It is a database containing analytically useful information
• D. It stores user credentials

Answer: (C)

A data warehouse is a database optimized for analytical querying, designed to store integrated, historical data from multiple sources to support decision making. The statement that best describes it is that it is a database containing analytically useful information. This captures both what it is (a database) and its purpose (holding information geared for analysis across time and sources). The other ideas don’t fit as well: metadata-only stores aren’t the warehouse itself, and storing user credentials is not the warehouse’s function. In short, a data warehouse is a database built to hold analytically useful, integrated, historical data for analysis.

A data warehouse is a database optimized for analytical querying, designed to store integrated, historical data from multiple sources to support decision making. The statement that best describes it is that it is a database containing analytically useful information. This captures both what it is (a database) and its purpose (holding information geared for analysis across time and sources). The other ideas don’t fit as well: metadata-only stores aren’t the warehouse itself, and storing user credentials is not the warehouse’s function. In short, a data warehouse is a database built to hold analytically useful, integrated, historical data for analysis.