Exam DP-203 topic 4 question 29 discussion

It must be DWU percentage. e.g. 95% is bad and 99% is very bad, and you don't need to look at anything else. If you looked at DWU used, what can you infer without also knowing the DWU limit (or DWU percentage)?

C. DWU percentage is the best metric to monitor to identify whether you must scale up to a higher service level to accommodate the current workloads in Azure Synapse Analytics. DWU percentage measures the percentage of Data Warehouse Units (DWUs) in use, which indicates how much processing power is being used. If the DWU percentage consistently exceeds a certain threshold, it may be necessary to scale up to a higher service level to accommodate the workload. DWU used, CPU percentage, and Data IO percentage are also important metrics to monitor, but they do not directly reflect the overall processing power available in the data warehouse.

"DWU used represents only a high-level representation of usage across the SQL pool and isn't meant to be a comprehensive indicator of utilization. To determine whether to scale up or down, consider all factors which can be impacted by DWU such as concurrency, memory, tempdb, and adaptive cache capacity." Source: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-resource-utilization-query-activity "DWU used percentage Represents a high-level representation of usage across the SQL pool. Measured by taking the maximum between CPU percentage and Data IO percentage." Source: https://learn.microsoft.com/en-us/azure/azure-monitor/reference/supported-metrics/microsoft-synapse-workspaces-sqlpools-metrics Although a little bit confusing at first read, due to the answer misleading options, the correct answer is clearly C.

DWU (Data Warehouse Unit) percentage is the best metric to monitor when determining if you need to scale up to a higher service level. It shows how much of the currently allocated compute resources are being used, indicating whether the current level is sufficient or if scaling up is necessary.

If you are concerned about whether you need to scale up to a higher service level, then DWU used is the most important metric to monitor. If you are concerned about how your workload is using your resources, then DWU percentage can be a helpful secondary metric.

Chatgpt : Knowing the absolute number of DWUs used (option A) doesn't provide complete information unless you also know the total DWUs available. On the other hand, the DWU percentage directly indicates how much of the available compute capacity is being used, which is a more informative metric for deciding whether scaling is needed. Therefore, the best metric to monitor to identify whether you need to scale up to a higher service level to accommodate the current workloads would indeed be: C. DWU percentage

C - DWU Percentage

C is the best.

Percentage should be way more useful than units itself.

i vote for C because only the % used is meaningful

I 100% agree with C. How will you know by a UNIT value if it's sufficient or not? You would need to check the percentage consumed out of total capacity, right? Hence, in my logical and design views it must be C --> DWU Percentage.

DWU used is the metric to use, if only one best answer is expected. option A.

As given in the document and explanation, DWU used = DWU limit * DWU percentage, it comprises limit and percentage. The question also states that more than one answer may achieve the goal and we are supposed to select the best answer, I think DWU used gives the best metric.

Which is the best one, DWU used or DWU percentage? We need to select one.

AC Both are answers

should be both DWU metrics