A data warehouse is designed for analytical workloads (OLAP) , not transactional workloads (OLTP).

It integrates data from multiple sources and supports complex queries, aggregations, and reporting for decision-making.

A. storage for transactional LOB apps → describes OLTP (e.g., SQL Server, Azure SQL Database), not a data warehouse.

B. transformation services → describes ETL/ELT pipelines (e.g., Data Factory), not the warehouse itself.

C. read-only storage of historical data → partially true but too narrow; the key feature is analytics, not just storage.

D. answers to complex queries across multiple sources → Correct and complete definition.

Correct Answer: D