ExamTopics Logo
Mail Us[email protected]
Menu
Apics Discussions
exam questions

Exam CSCP All Questions

View all questions & answers for the CSCP exam
Go to Exam

Exam DP-203 topic 4 question 45 discussion

Actual exam question from APICS's CSCP
Question #: 45
Topic #: 1
[All CSCP Questions]

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 Hide Answer
Suggested Answer: C 🗳️
by henryphchan at May 13, 2023, 5:59 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
MBRSDG
3 months, 1 week 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
...
AG_IT
3 months, 3 weeks ago
Selected Answer: C
correct ans c
upvoted 1 times
...
kkk5566
10 months, 2 weeks ago
Selected Answer: C
Repeated
upvoted 2 times
...
darshilparmar
1 year, 1 month ago
Repeat Questons
upvoted 4 times
...
henryphchan
1 year, 1 month ago
Selected Answer: C
Answer is C, and it's a repeated question
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago