Implementing an Azure Data Solution (legacy) — Question 9

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.

Answer options

• A. CPU percentage
• B. DWU used
• C. DWU percentage
• D. Data IO percentage

Correct answer: B

Explanation

The best metric to monitor is 'DWU used' because it directly indicates how much of the Data Warehouse Units are being utilized, which is critical for assessing the need for scaling. While 'CPU percentage', 'DWU percentage', and 'Data IO percentage' can provide insights into performance, they do not specifically reflect the overall workload capacity in terms of DWUs, making them less effective for this specific requirement.