Exam DP-203 topic 4 question 47 discussion

Repeated 4 times

Seems like this question is time travelling. saw it few pages back couple times already and here it is again. lol.

Question is being repeated multiple times, don't know why people select anything other than B. If it's something to do with "Commonly used queries" then it's 99% of the time cache

The correct metric to monitor is C. Data Warehouse Units (DWU) used. DWUs are the units of resource consumption in Azure Synapse Analytics. Each DWU represents a certain amount of processing power, memory, and storage capacity. When users run queries, they consume DWUs. In this case, users report slow performance when they run commonly used queries. This suggests that the performance issues are likely due to resource contention. If the commonly used queries are consuming a large amount of DWUs, then there may not be enough resources available for other queries to run efficiently. By monitoring DWU usage, you can identify which queries are consuming the most resources and take steps to optimize them or to scale your Azure Synapse Analytics workspace.

Correct Answer: C Why not A ? While the DWU percentage can provide insights into whether your workload is more CPU or IO intensive, the DWU used can provide a more direct measure of the overall resource utilization1. This can be more helpful in identifying if resource contention (i.e., your workload is demanding more resources than are available) is causing the slow performance of commonly used queries R: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-resource-utilization-query-activity

Monitoring DWU used (Option C) can certainly be part of a comprehensive approach to diagnosing the performance issues, focusing on the cache hit percentage (Option B) might offer a more targeted way to address the specific problem described in the scenario.

Repeated

Repeated