Which of the following statements about data warehouses is accurate?

• A. They are typically used to store operational transactions
• B. They provide a single consolidated view of managerial information
• C. They eliminate the need for primary keys in source systems
• D. They store only structured data

Answer: (B)

At the heart of what a data warehouse is for is giving decision makers a single, consistent view of information from many different parts of the business. By pulling data from multiple source systems—like finance, sales, and operations—into one integrated place and organizing it around subjects (such as customers, products, or time periods), a data warehouse makes it possible to run dashboards, reports, and analyses with uniform definitions and measurements. This consolidated, time-variant view supports trend analysis and informed management decisions, which is why that statement is accurate.

Operational transactions live in systems built for day-to-day updates and high write throughput; data warehouses are designed for queries and analysis rather than heavy transaction processing. The claim about eliminating primary keys in source systems is incorrect because keys exist in source systems and the warehouse often uses surrogate keys or maintains keys to preserve relationships and history. Finally, while traditional warehouses store structured data in dimensional models, many modern warehouses also handle semi-structured data, so the claim that they store only structured data is too absolute.