What is the primary purpose of a data warehouse?

Transactional LOB applications typically use Online Transaction Processing (OLTP) databases, not data warehouses, which are optimized for high-volume reads and writes.

While data warehouses are populated through ETL/ELT processes that involve transformation, providing transformation services is the role of an ETL/ELT tool, not the primary purpose of the data warehouse itself.

Data warehouses are specifically built to store large volumes of historical data, which can be relational or non-relational, optimized for complex query and analysis rather than transactional writes. This enables reporting and analytical systems to query consistent historical snapshots without impacting operational systems.

Providing answers to complex queries is a benefit or use case of a data warehouse, but its primary purpose or function is to provide the storage and structure for that historical data, which then enables such queries.