What is the primary purpose of a data warehouse?

What is the primary purpose of a data warehouse?
A . to provide answers to complex queries that rely on data from multiple sources
B. to provide transformation services between source and target data stores
C. to provide read-only storage of relational and non-relational historical data
D. to provide storage for transactional line-of-business (LOB) applications

View Answer

Answer: A

Explanation:

Consider using a data warehouse when you need to keep historical data separate from thesource transaction systems for performance reasons. Data warehouses make it easy toaccess historical data from multiple locations, by providing a centralized location usingcommon formats, keys, and data models.

Query both relational and nonrelational data.

Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing