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.
DWU percentage is the best metric to monitor because it directly indicates the utilization of the allocated Data Warehouse Units (DWUs), reflecting both the CPU and Data IO usage. This comprehensive measure helps in determining if the current service level is sufficient or if scaling up is necessary based on the percentage of resources being utilized. Monitoring DWU percentage offers a clear overview of how much of the available compute capacity is being used, making it an effective metric for making scaling decisions.
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.
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.
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.
Percentage should be way more useful than units itself.
DWU used is the metric to use, if only one best answer is expected. option A.
should be both DWU metrics
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.
DWU percentage is the percentage of Data Warehouse Units (DWUs) used by the data warehouse. It is calculated as the maximum of CPU percentage and Data IO percentage. If the DWU percentage is consistently high, it may indicate that you need to scale up to a higher service level to accommodate the current workloads
Which is the best one, DWU used or DWU percentage? We need to select one.
AC Both are answers