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 B. Cache hit percentage. Monitor and troubleshoot slow query performance by determining whether your workload is optimally leveraging the adaptive cache for dedicated SQL pools. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-how-to-monitor-cache

Submitted by anna_se· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

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

ADWU percentage
BCache hit percentage
CDWU limit
DData IO percentage

How the community answered

(32 responses)

A
6% (2)
B
81% (26)
C
9% (3)
D
3% (1)

Explanation

Monitor and troubleshoot slow query performance by determining whether your workload is optimally leveraging the adaptive cache for dedicated SQL pools. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-how-to-monitor-cache

Topics

#Azure Synapse Analytics#cache hit percentage#query performance#DWU monitoring

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice