You have a SQL pool in Azure Synapse. A user reports that queries against the pool take longer than expected to complete. You need to add monitoring to the underlying storage to help diagnose the…

The correct answer is A. Cache used percentage E. Cache hit percentage. A: Cache used is the sum of all bytes in the local SSD cache across all nodes and cache capacity is the sum of the storage capacity of the local SSD cache across all nodes. E: Cache hits is the sum of all columnstore segments hits in the local SSD cache and cache miss is the…

Submitted by noor.lb· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

Question

You have a SQL pool in Azure Synapse. A user reports that queries against the pool take longer than expected to complete. You need to add monitoring to the underlying storage to help diagnose the issue. Which two metrics should you monitor? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

ACache used percentage
BDWU Limit
CSnapshot Storage Size
DActive queries
ECache hit percentage

How the community answered

(23 responses)

A
78% (18)
B
13% (3)
C
4% (1)
D
4% (1)

Explanation

A: Cache used is the sum of all bytes in the local SSD cache across all nodes and cache capacity is the sum of the storage capacity of the local SSD cache across all nodes. E: Cache hits is the sum of all columnstore segments hits in the local SSD cache and cache miss is the columnstore segments misses in the local SSD cache summed across all nodes https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-concept-resource-utilization-query-activity

Topics

#Synapse SQL pool#cache metrics#performance monitoring#storage optimization

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice