Which statement best describes a data warehouse’s purpose?

Which statement best describes a data warehouse’s purpose?

• A. To consolidate integrated data from multiple sources for analysis and reporting to support business intelligence.
• B. To replace the enterprise resource planning system.
• C. To store only current operational data.
• D. To function as a firewall.

Answer: (A)

A data warehouse consolidates data from multiple sources into a single place so analysts can perform analysis, reporting, and business intelligence. This centralized, integrated store is designed for read-oriented access and complex queries, letting you compare data across departments and over time to spot trends and inform decisions. The data is typically historical and time-variant, which provides context for performance over periods rather than just the current snapshot. The ETL process—extracting data from source systems, transforming it for consistency, and loading it into the warehouse—creates a unified view that supports reliable analytics and BI dashboards. This purpose aligns with why organizations build data warehouses: to enable comprehensive analysis and reporting for informed decision-making. It isn’t meant to replace an ERP system, which handles day-to-day transactions; it doesn’t store only current operational data, since historical data is essential for trend analysis; and it isn’t a firewall, which is a security function.

A data warehouse consolidates data from multiple sources into a single place so analysts can perform analysis, reporting, and business intelligence. This centralized, integrated store is designed for read-oriented access and complex queries, letting you compare data across departments and over time to spot trends and inform decisions. The data is typically historical and time-variant, which provides context for performance over periods rather than just the current snapshot. The ETL process—extracting data from source systems, transforming it for consistency, and loading it into the warehouse—creates a unified view that supports reliable analytics and BI dashboards. This purpose aligns with why organizations build data warehouses: to enable comprehensive analysis and reporting for informed decision-making. It isn’t meant to replace an ERP system, which handles day-to-day transactions; it doesn’t store only current operational data, since historical data is essential for trend analysis; and it isn’t a firewall, which is a security function.