Microsoft Exam DP-900 Topic 3 Question 37 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 37
Topic #: 3

[All DP-900 Questions]

What is the primary purpose of a data warehouse?

Ato provide answers to complex queries that rely on data from multiple sources

Bto provide transformation services between source and target data stores

Cto provide read-only storage of relational and non-relational historical data

Dto provide storage for transactional line-of-business (LOB) applications

Show Suggested Answer

Suggested Answer: C

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.

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

by Tarra at May 05, 2022, 07:17 PM

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!