mediumMultiple SelectObjective-mapped
DP-203 Practice Question: A company uses Azure Synapse Analytics dedicated…
A company uses Azure Synapse Analytics dedicated SQL pool for a data warehouse. They notice that some queries are using more memory than expected, causing resource contention. Which TWO actions should they take to diagnose and optimize memory usage?
⚠ Common exam trap
Many candidates confuse scaling up the DWU (Option C) as a diagnostic action, but it is a reactive scaling measure that does not help identify which queries are causing the memory issue, whereas querying the DMV and adjusting resource classes are targeted diagnostic and optimization steps.
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
✓
Increase the resource class for the users running the heavy queries.
Increasing the resource class for users running heavy queries allocates more memory to those queries, reducing resource contention by ensuring they have sufficient memory to execute efficiently. Option D is correct because querying sys.dm_pdw_exec_requests DMV allows you to identify queries with high memory grants, which is the first step in diagnosing which queries are consuming excessive memory and need optimization.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enable result-set caching.
Why it's wrong here
Result-set caching does not address memory usage of running queries.
- ✓
Increase the resource class for the users running the heavy queries.
Why this is correct
Larger resource classes provide more memory per query.
- ✗
Scale up the DWU setting.
Why it's wrong here
Scaling up increases overall resources but does not target specific query memory issues.
- ✓
Query the sys.dm_pdw_exec_requests DMV to identify queries with high memory grants.
Why this is correct
This DMV provides information on memory grants per query.
- ✗
Rebuild clustered columnstore indexes.
Why it's wrong here
Index rebuild does not directly affect query memory grants.
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.