What is the primary purpose of a data warehouse and ETL in MIPC analytics?

• A. Store only operational data in real time with no historical retention.
• B. ETL is only for archiving logs.
• C. Data warehouses replace transactional databases.
• D. Centralize data for analytics; move data from sources into the warehouse for unified reporting and historical analysis.

Answer: (D)

Centralizing data for analytics via a data warehouse and ETL is what this item tests. A data warehouse serves as a single, organized repository that combines data from multiple source systems, making it possible to run analytics, generate unified reports, and compare trends over time. ETL—extracting data from each source, transforming it into a consistent format, and loading it into the warehouse—prepares and moves that data so analytics can be accurate and efficient. This combination enables historical analysis and cross-system reporting, which is essential for gaining insights across the business. The other options miss the point: real-time-only storage with no history, ETL being only for archiving logs, or warehouses replacing transactional databases describe incomplete or incorrect roles.