Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 3 question 17 discussion

Actual exam question from Microsoft's DP-300

Question #: 17
Topic #: 3

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. Local tempdb percentage
B. DWU percentage
C. Data Warehouse Units (DWU) used
D. Cache hit percentage

Show Suggested Answer

Suggested Answer: D 🗳️

by ss1516 at Nov. 11, 2021, 2:52 p.m.

Comments

Submit Cancel

ofzrgrz

9 months ago

DP-203 question, you can skip.

upvoted 2 times

...

Backy

1 year, 11 months ago

Answer: D // slow for frequent vs infrequent suggests issues with cache, so answer is D // tempdb does not care about frequent vs infrequent

upvoted 2 times

...

cusman

2 years, 2 months ago

DP-203

upvoted 3 times

Ciupaz

1 year, 8 months ago

Yes, this question is for DP-203 exam.

upvoted 2 times

...

CaptainJameson

2 years, 2 months ago

Selected Answer: D

Could be low cache hit ratio, because infrequent queries were already slower, so they don't notice any difference, but regular queries do now. Could also be tempdb as suggested, but then infrequent queries would also be affected depending on the query. Out of the options and unknowns, I would choose cache hit ratio.

upvoted 4 times

...

o2091

2 years, 6 months ago

Is D correct?

upvoted 2 times

...

ss1516

2 years, 6 months ago

D is correct. https://docs.microsoft.com/da-dk/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-monitor-cache

upvoted 4 times

kutty09

2 years, 2 months ago

Frequent queries performance is also slow so D is wrong I think.

upvoted 1 times

...

quermi

2 years, 6 months ago

If the cache hit ratio is low, it means that new or infrequent queries last a short time in the cache and their performance would be bad, but these types of queries have no problems. Therefore answer D is not correct

upvoted 3 times

Backy

1 year, 10 months ago

The question does not say that "infrequent queries" are good or fast. It says that infrequent queries are unchanged. The issue is that the frequent queries are slower than before, meaning there are more infrequent queries now or they are more bunched together than before and fill up the cache before the frequent queries have a chance to run. Low cache hit would show it. The solution is a bigger cache or change the run patterns

upvoted 2 times

...