DP-203 Question #217: Real Exam Question with Answer & Explanation

Question

You have an enterprise data warehouse in Azure Synapse Analytics. You need to monitor the data warehouse to identify whether you must scale up to a higher service level to accommodate the current workloads. Which is the best metric to monitor? More than one answer choice may achieve the goal. Select the BEST answer.

Options

• AData IO percentage
• BCPU percentage
• CDWU used
• DDWU percentage

Explanation

DWU used directly measures the actual compute units being consumed against your provisioned capacity, making it the clearest signal that you're approaching the ceiling of your current service level and need to scale up. It tells you how much of your allocated DWU is in use in absolute terms, which is what drives the scaling decision.

DWU percentage (D) sounds similar but is a derived ratio - while it shows utilization as a percentage, Microsoft's own guidance designates DWU used as the primary metric for scaling decisions because it reflects real consumption against a fixed baseline, not a relative one that shifts as you rescale.

CPU percentage (B) and Data IO percentage (A) are component-level resource metrics - they indicate why a workload is slow (compute-bound vs. IO-bound), but they don't directly tell you whether your overall DWU allocation is insufficient; a bottleneck in one subsystem doesn't always mean you need a higher service level.

Memory tip: Think of it this way - DWU used is your odometer (actual consumption), DWU percentage is your speedometer (relative rate), and CPU/IO are your engine diagnostics. You scale up based on how much fuel you're burning (DWU used), not the dashboard gauges.

No community discussion yet for this question.