Exam DP-203 topic 4 question 16 discussion

Actual exam question from Microsoft's DP-203

Question #: 16
Topic #: 4

You manage an enterprise data warehouse in Azure Synapse Analytics.
Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.
You need to monitor resource utilization to determine the source of the performance issues.
Which metric should you monitor?

A. DWU percentage
B. Cache hit percentage
C. DWU limit
D. Data IO percentage

Show Suggested Answer

Suggested Answer: B 🗳️
Monitor and troubleshoot slow query performance by determining whether your workload is optimally leveraging the adaptive cache for dedicated SQL pools.
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-monitor-cache

by HaBroNounen at Jan. 2, 2022, 12:29 p.m.

Comments

Submit Cancel

HaBroNounen

Highly Voted 2 years, 7 months ago

correct

upvoted 8 times

...

nadavw

Most Recent 5 months, 2 weeks ago

Selected Answer: A

DWU percentage will show issues in resources

upvoted 1 times

...

Asheesh1909

5 months, 3 weeks ago

Selected Answer: A

Cache hit percentage: This measures how often data is retrieved from cache, but it won't directly indicate issues with resource utilization causing slow queries. DWU percentage The DWU (Data Warehouse Units) percentage represents the resource utilization in terms of the computational power allocated to the data warehouse. Monitoring this metric can help identify if the current DWU allocation is insufficient for handling the load of commonly used queries, leading to slow performance. please correct if my thinking is not wrong

upvoted 2 times

...

kkk5566

11 months, 2 weeks ago

Selected Answer: B

repeted

upvoted 2 times

...

Deeksha1234

2 years ago

correct

upvoted 4 times

...