DP-203 Practice Question: Secure, monitor, and optimize data storage and data processing
You are a data engineer for a healthcare company. You have a production Azure Synapse Analytics dedicated SQL pool (DW500c) that hosts patient data. The pool is used for both ETL and reporting. You need to ensure that reporting queries always get resources even during heavy ETL loads. You also need to monitor query performance and set up alerts when certain queries exceed a threshold. You have configured workload management using workload groups and classifiers. However, reporting queries are still waiting for resources when ETL is running. You check the sys.dm_pdw_exec_requests DMV and see that ETL queries are using the largest resource class. You need to modify the configuration to guarantee resources for reporting. What should you do?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Create a new workload group for reporting with min_percentage_resource set to 30%
Creating a separate workload group for reporting with a minimum percentage of resources (min_percentage_resource) guarantees a baseline amount of resources for reporting queries, isolating them from ETL even when ETL is using a large resource class. This is the correct solution. Option B (importance) can help order queries within the same group but does not guarantee resource availability if the group has no minimum. Option C (increasing DWU) adds more overall resources but does not isolate; reporting may still be starved if ETL uses them. Option D (changing classifier) does not guarantee resources because both queries would compete in the same group.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Create a new workload group for reporting with min_percentage_resource set to 30%
Why this is correct
Guarantees a minimum resource allocation for reporting.
- ✗
Set importance to HIGH for the reporting workload group
Why it's wrong here
Importance helps but without min resources, can still be starved.
- ✗
Increase the DWU setting to DW1000c
Why it's wrong here
Increases overall resources but does not guarantee isolation.
- ✗
Change the classifier for reporting queries to use the same workload group as ETL but with a different resource class
Why it's wrong here
Does not isolate resources.
Go deeper
Related to this question
About these practice questions
This DP-203 question is part of Courseiva's 760-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-203 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-203 exam.