Free Microsoft Azure DP-900 Actual Exam Questions - Question 7 Discussion

Data warehouses prioritize reads over updates to ensure fast query performance.

I’d go with the option that says data is mostly read and rarely updated too. Since data warehouses are designed for complex queries and reporting, heavy writes or frequent updates just don’t make sense. It’s all about fast querying and analysis, not transaction processing.

I think it's about data being read-heavy since warehouses focus on analysis, so something like "is mostly read and rarely updated" fits best. Updates would slow down reporting otherwise.

Usually gets queried way more than it gets updated, so read-optimized.