Exam DP-203 topic 4 question 45 discussion

Actual exam question from APICS's CSCP

Question #: 45
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. Data IO percentage
C. Cache hit percentage
D. CPU percentage

Show Suggested Answer

Suggested Answer: C 🗳️

by henryphchan at May 13, 2023, 5:59 p.m.

Comments

Submit Cancel

MBRSDG

9 months, 3 weeks ago

Selected Answer: C

Correct answer is C since the question is referringo to commonly used queries, so, in a good scenario, we'd expect that the cache HITs are high. CPU could make sense, but cache is more relevant.

upvoted 1 times

...