DP-203 Certification Practice Question #250

Question

You manage an enterprise data warehouse in Azure Synapse Analytics.
Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.
You need to monitor resource utilization to determine the source of the performance issues.
Which metric should you monitor?

Accepted Answer

When the scenario emphasizes infrequent execution and minimizing cost, the right design principle is to avoid always-on compute and use pay-per-use execution where possible. That aligns with Microsoft’s general guidance across Synapse and Azure data services, where serverless or on-demand models reduce idle spend. Confidence is a little lower because the dump discussion does not provide much additional detail beyond the selected answer.

More DP-203 practice questions