MENU
What is the primary purpose of a data warehouse?
Suggested Answer: C
Get Premium DP-900 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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
12 comments · newest first
WE
Wei
12 months ago
Really? I thought data warehouses were just for storage.
NI
Niesha
1 year ago
B seems off to me, that's more ETL stuff.
SA
Salome
1 year ago
Wait, isn't it also about integrating data from different sources?
SA
Sabine
1 year ago
I think C is more accurate, though.
RI
Rickie
1 year ago
Definitely A! It's all about complex queries.
MA
Ma
1 year 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.
DA
Dana
1 year 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.
JA
Jarvis
1 year 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.
AN
Annice
1 year 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.
LA
Lai
1 year 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.
FR
France
1 year 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.
LA
Lashandra
1 year 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.