Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-203 Topic 2 Question 88 Discussion

Actual exam question for Microsoft's DP-203 exam
Question #: 88
Topic #: 2
[All DP-203 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.

Show Suggested Answer Hide Answer
Suggested Answer: A, B

Contribute your Thoughts:

Pamella
19 hours ago
Definitely need to keep an eye on the Active queries and DWU Limit. Those are key indicators of the system's performance. I wonder if they'll throw in a curveball like 'Disk IOPS' or something?
upvoted 0 times
...
Georgeanna
4 days ago
I agree with Audry. Monitoring those metrics can help us diagnose the slow queries.
upvoted 0 times
...
Audry
5 days ago
I think we should monitor Cache hit percentage and Active queries.
upvoted 0 times
...
Donte
6 days ago
I also think DWU Limit is important to monitor. It can help us determine if the performance issue is related to the amount of resources allocated to the SQL pool.
upvoted 0 times
...
Annmarie
6 days ago
Hmm, this seems straightforward. I'd go with Cache hit percentage and Active queries. Monitoring cache usage and query activity should give me a good idea of what's going on under the hood.
upvoted 0 times
...
Stephaine
8 days ago
I agree with Barbra. Cache hit percentage can help us understand how well our cache is performing, and monitoring Active queries can give us insights into the workload on the SQL pool.
upvoted 0 times
...
Barbra
10 days ago
I think we should monitor Cache hit percentage and Active queries.
upvoted 0 times
...

Save Cancel