Microsoft DP-900 Exam - 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

Wei

4 months ago

Really? I thought data warehouses were just for storage.

upvoted 0 times

...

Niesha

4 months ago

B seems off to me, that's more ETL stuff.

upvoted 0 times

...

Salome

4 months ago

Wait, isn't it also about integrating data from different sources?

upvoted 0 times

...

Sabine

5 months ago

I think C is more accurate, though.

upvoted 0 times

...

Rickie

5 months ago

Definitely A! It's all about complex queries.

upvoted 0 times

...

Ma

5 months ago

I feel like option D is definitely not right since it mentions transactional applications, which are more for operational databases. I think it’s between A and C.

upvoted 0 times

...

Dana

5 months ago

I recall that data warehouses store historical data, so option C seems plausible. But I’m a bit confused about the read-only aspect.

upvoted 0 times

...

Jarvis

5 months ago

I’m not entirely sure, but I remember something about transformation services being important. Maybe option B? But it feels like that’s more about ETL processes.

upvoted 0 times

...

Annice

5 months ago

I think the main purpose is to answer complex queries, so I’m leaning towards option A. It makes sense since data warehouses pull from multiple sources.

upvoted 0 times

...

Lai

5 months ago

Okay, I think I've got a strategy here. Since we have multiple subscriptions, creating a new management group and assigning the security group the User Access Administrator role seems like the best way to meet the requirements.

upvoted 0 times

...

France

5 months ago

I'm feeling pretty confident about this one. The scenario provides a good amount of context, and the responsibilities seem straightforward to assign to the different roles.

upvoted 0 times

...

Lashandra

5 months ago

Okay, I think the key here is that transfer prices based on actual cost can lead to suboptimal decisions for the company as a whole. That makes sense - the department transferring the goods might not be incentivized to minimize costs if they just pass them along.

upvoted 0 times

...