Secure, monitor, and optimize data storage and data processing →mediumMultiple ChoiceObjective-mapped
DP-203 Practice Question: Secure, monitor, and optimize data storage and data processing
You are monitoring an Azure Synapse Analytics dedicated SQL pool and notice that some queries are experiencing high wait times due to concurrency slots being exhausted. You need to optimize the workload to reduce contention. Which three actions should you take? (Select three.)
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 workload groups with different importance levels.
Options B, C, and D are correct. Workload groups with different importance levels allow you to prioritize critical queries, reducing contention. Workload isolation limits resources for a group, preventing resource-intensive queries from blocking others. Workload classification routes queries to appropriate groups based on criteria. Option A is incorrect because increasing DWU increases concurrency slots but may raise costs. Option E is incorrect because result-set caching does not affect concurrency slot usage.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Increase the data warehouse service level (DWU).
Why it's wrong here
Increasing DWU increases concurrency slots but does not directly optimize workload to reduce contention; it may also increase cost.
- ✓
Create workload groups with different importance levels.
Why this is correct
Creating workload groups with different importance levels allows critical queries to be prioritized, reducing contention.
- ✓
Configure workload isolation to limit the amount of resources a workload group can use.
Why this is correct
Configuring workload isolation limits the amount of resources a workload group can use, preventing resource-intensive queries from blocking others.
- ✓
Use workload classification to assign queries to appropriate workload groups.
Why this is correct
Using workload classification assigns queries to appropriate workload groups based on criteria, helping to manage concurrency and reduce contention.
- ✗
Enable result-set caching for frequently executed queries.
Why it's wrong here
Result-set caching does not affect concurrency slot usage; it only improves performance for repeated queries.
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 →
Same concept, more angles
1 more way this is tested on DP-203
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. You are monitoring an Azure Synapse Analytics dedicated SQL pool and notice that queries are experiencing excessive wait time due to concurrency slots being exhausted. What is the recommended approach to improve concurrency without increasing cost?
medium- A.Create additional workload groups and assign queries to them.
- ✓ B.Classify queries using workload classification and assign lower importance to reduce concurrency slot usage.
- C.Scale up the dedicated SQL pool to a higher service level.
- D.Change the distribution type of tables to round-robin.
Why B: By classifying queries with workload classification and assigning lower importance to background or non-critical queries, those queries consume fewer concurrency slots, freeing slots for higher-priority queries without additional cost. Option A is incorrect because workload groups manage resources but do not directly reduce per-query concurrency slot usage; they allocate resources among groups but total concurrency slots remain fixed. Option C is incorrect because scaling up increases cost without necessarily improving concurrency efficiency. Option D is incorrect because table distribution type (e.g., round-robin) affects query performance and data movement, not concurrency slot consumption.
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.