Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-900 Exam - Topic 3 Question 37 Discussion

What is the primary purpose of a data warehouse?
C) to provide read-only storage of relational and non-relational historical data
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
D) to provide storage for transactional line-of-business (LOB) applications

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Wei
10 months ago
Really? I thought data warehouses were just for storage.
upvoted 0 times
...
Niesha
10 months ago
B seems off to me, that's more ETL stuff.
upvoted 0 times
...
Salome
11 months ago
Wait, isn't it also about integrating data from different sources?
upvoted 0 times
...
Sabine
11 months ago
I think C is more accurate, though.
upvoted 0 times
...
Rickie
11 months ago
Definitely A! It's all about complex queries.
upvoted 0 times
...
Ma
11 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
11 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
11 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
11 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
11 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
11 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
11 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
...

Save Cancel