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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

by Merlyn at May 02, 2024, 06:10 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Alfred
2 days ago
I believe Cache used percentage and DWU Limit are also important to monitor for performance issues.
upvoted 0 times
...
Latosha
3 days ago
I'm gonna go with Cache used percentage and Snapshot Storage Size. Gotta make sure that cache is working hard and the storage isn't getting bogged down, you know? Although, maybe I should throw in a joke about the user being 'slower than molasses' in there somewhere.
upvoted 0 times
...
Pamella
4 days 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
7 days ago
I agree with Audry. Monitoring those metrics can help us diagnose the slow queries.
upvoted 0 times
...
Audry
8 days ago
I think we should monitor Cache hit percentage and Active queries.
upvoted 0 times
...
Donte
9 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
9 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
11 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
13 days ago
I think we should monitor Cache hit percentage and Active queries.
upvoted 0 times
...

Save Cancel