Data Engineering on Microsoft Azure — Question 35

You have a SQL pool in Azure Synapse.
A user reports that queries against the pool take longer than expected to complete. You determine that the issue relates to queried columnstore segments.
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.

Answer options

• A. Snapshot Storage Size
• B. Cache used percentage
• C. DWU Limit
• D. Cache hit percentage

Correct answer: B, D

Explanation

Monitoring the 'Cache used percentage' (B) is essential as it indicates how much of the cache is being utilized, which can impact query performance. Additionally, the 'Cache hit percentage' (D) shows how effective the cache is at serving requests, as a higher percentage suggests better performance. The other options, while useful in other contexts, do not directly relate to the efficiency of query execution in this scenario.