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.

ACache used percentage

BDWU Limit

CSnapshot Storage Size

DActive queries

ECache hit percentage

Show Suggested 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

Deangelo

5 days ago

Ooh, this is a tricky one. I'm gonna go with Active queries and Cache hit percentage. Seems like the obvious choices, but you never know with these certification exams. Maybe I should also add a funny comment about the user being 'as slow as a herd of turtles on a hot day'.

upvoted 0 times

...

Alfred

16 days ago

I believe Cache used percentage and DWU Limit are also important to monitor for performance issues.

upvoted 0 times

...

Latosha

17 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

18 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

21 days ago

I agree with Audry. Monitoring those metrics can help us diagnose the slow queries.

upvoted 0 times

...

Audry

22 days ago

I think we should monitor Cache hit percentage and Active queries.

upvoted 0 times

...

Donte

23 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

23 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

Jules

3 days ago

Cache hit percentage can help us understand how well queries are utilizing cache.

upvoted 0 times

...

Kattie

5 days ago

I agree, monitoring cache hit percentage and active queries is a good start.

upvoted 0 times

...

Stephaine

25 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

27 days ago

I think we should monitor Cache hit percentage and Active queries.

upvoted 0 times

...