You manage an enterprise data warehouse in Azure Synapse Analytics. Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used…

The correct answer is D. Cache hit percentage. You can use Azure Monitor to view cache metrics to troubleshoot query performance. The key metrics for troubleshooting the cache are Cache hit percentage and Cache used Possible scenario: Your current working data set cannot fit into the cache which causes a low cache hit…

Submitted by satoshi_tk· Mar 6, 2026Optimize query performance

Question

You manage an enterprise data warehouse in Azure Synapse Analytics. Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries. You need to monitor resource utilization to determine the source of the performance issues. Which metric should you monitor?

Options

ALocal tempdb percentage
BDWU percentage
CData Warehouse Units (DWU) used
DCache hit percentage

How the community answered

(31 responses)

A
3% (1)
B
6% (2)
C
10% (3)
D
81% (25)

Explanation

You can use Azure Monitor to view cache metrics to troubleshoot query performance. The key metrics for troubleshooting the cache are Cache hit percentage and Cache used Possible scenario: Your current working data set cannot fit into the cache which causes a low cache hit percentage due to physical reads. Consider scaling up your performance level and rerun your workload to populate the cache. https://docs.microsoft.com/da-dk/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-how-to-monitor-cache

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice