Answer: DWU percentage

## Detailed Explanation When determining whether to scale up an Azure Synapse Analytics data warehouse to a higher service level, **DWU percentage** is the optimal metric to monitor for several key reasons: ### Why DWU Percentage is the Best Choice 1. **Comprehensive Resource Utilization Indicator**: DWU percentage represents the maximum utilization between CPU percentage and Data IO percentage, providing a holistic view of resource consumption across the data warehouse. 2. **Relative Capacity Measurement**: Unlike absolute DWU values, the percentage format immediately indicates how close the current workload is to the capacity limits of the current service level. A consistently high DWU percentage (e.g., 90-100%) clearly signals that scaling up is necessary. 3. **Direct Scaling Indicator**: Microsoft's official documentation explicitly recommends DWU percentage as the primary metric for scaling decisions. It directly correlates with whether the current service level can handle the workload effectively. 4. **Threshold-Based Decision Making**: With DWU percentage, you can establish clear thresholds (e.g., sustained usage above 80-90%) to trigger scaling operations, making it actionable for performance management. ### Analysis of Other Options - **DWU Used (Option A)**: While this shows the absolute number of Data Warehouse Units being consumed, it lacks context without knowing the total available capacity. A DWU used value of 500 could be concerning for a DW500 service level but perfectly acceptable for a DW3000 service level. - **CPU Percentage (Option B)**: This only measures processor utilization and doesn't account for other critical resources like I/O operations, which can be equally important bottlenecks in data warehouse workloads. - **Data IO Percentage (Option D)**: Similar to CPU percentage, this provides only partial insight into resource utilization and doesn't represent the complete picture of data warehouse performance. ### Best Practice Recommendation For scaling decisions in Azure Synapse Analytics, monitor DWU percentage over time to identify sustained high utilization patterns. When DWU percentage consistently approaches or exceeds 90%, it strongly indicates the need to scale up to a higher service level to maintain optimal performance and accommodate current workloads effectively.

Author: LeetQuiz Editorial Team