Microsoft Azure Data Fundamentals Questions and Answers
Question 17
Select the answer that correctly completes the sentence.
Options:
Answer:
Answer:
Question 18
What is the primary purpose of a data warehouse?
Options:
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.