Exam DP-203 topic 1 question 95 discussion

Actual exam question from Microsoft's DP-203

Question #: 95
Topic #: 1

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 limit
B. Cache hit percentage
C. Local tempdb percentage
D. Data IO percentage

Show Suggested Answer

Suggested Answer: B 🗳️

by MSExpert at Aug. 10, 2023, 1:30 a.m.

Comments

Submit Cancel

MSExpert

Highly Voted 1 year, 2 months ago

Correct

upvoted 6 times

...

ELJORDAN23

Most Recent 9 months, 3 weeks ago

Selected Answer: B

Got this question on my exam on january 17, answer B is correct.

upvoted 1 times

...

ndangalasi

1 year ago

Selected Answer: B

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-monitor-cache

upvoted 3 times

...

Vanq69

1 year, 1 month ago

B. Cache hit percentage should be correct since it only affects common used queries, which should be saved and loaded from cache.

upvoted 3 times

...

kkk5566

1 year, 2 months ago

Selected Answer: B

B is correct

upvoted 2 times

...

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 95 discussion

Comments

MSExpert

ELJORDAN23

ndangalasi

Vanq69

kkk5566

SY0-701