Microsoft Exam DP-200 Topic 5 Question 10 Discussion

Actual exam question for Microsoft's DP-200 exam

Question #: 10
Topic #: 5

[All DP-200 Questions]

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.

ACache used percentage

BDWU Limit

CSnapshot Storage Size

DActive queries

ECache hit percentage

Show Suggested Answer

Suggested Answer: A, E

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

by Joesph at May 04, 2022, 03:27 PM

Limited Time Offer

25%

Off

Get Premium DP-200 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!