Microsoft
DP-203 · Question #102
You have a SQL pool in Azure Synapse. A user reports that queries against the pool take longer than expected to complete. You need to add monitoring to the underlying storage to help diagnose the issu
Sign in or unlock DP-203 to reveal the answer and full explanation for question #102. The question stem and answer options stay visible for context.
Submitted by noor.lb· Mar 30, 2026Secure, monitor, and optimize data storage and data processing
Question
You have a SQL pool in Azure Synapse. A user reports that queries against the pool take longer than expected to complete. You need to add monitoring to the underlying storage to help diagnose the issue. Which two metrics should you monitor? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Options
- ACache used percentage
- BDWU Limit
- CSnapshot Storage Size
- DActive queries
- ECache hit percentage
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Synapse SQL pool#cache metrics#performance monitoring#storage optimization