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

Answer: C

Explanation:

Consider using a data warehouse when you need to keep historical data separate from the source transaction systems for performance reasons. Data warehouses make it easy to access historical data from multiple locations, by providing a centralized location using common 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

Latest DP-900 Dumps Valid Version with 134 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments