Exam DP-200 topic 5 question 2 discussion

Actual exam question from Microsoft's DP-200

Question #: 2
Topic #: 5

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.

A. Cache used percentage
B. DWU Limit
C. Snapshot Storage Size
D. Active queries
E. Cache hit percentage

Show Suggested Answer

Suggested Answer: AE 🗳️
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
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-resource-utilization-query-activity

by akash0680 at Dec. 17, 2020, 1:57 p.m.

Comments

Submit Cancel

cjh1912

4 years, 4 months ago

"To determine whether to scale up or down, consider all factors which can be impacted by DWU such as concurrency, memory, tempdb, and adaptive cache capacity. " with this in mind, can number of query be a possible correct answer as well? Ref : https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-resource-utilization-query-activity

upvoted 2 times

Alekx42

4 years ago

Maybe, but the number of active queries alone does not help much if you can't differentiate between the queries that are more resource-intesive and the ones that do not require much DWU.

upvoted 1 times

...

akash0680

4 years, 5 months ago

correct

upvoted 2 times

...