ExamGecko
Question list
Search
Search

Question 100 - COF-R02 discussion

Report
Export

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

A.
Use multi-clustered warehousing to scale out warehouse capacity.
Answers
A.
Use multi-clustered warehousing to scale out warehouse capacity.
B.
Scale up the warehouse size to allow Queries to execute faster.
Answers
B.
Scale up the warehouse size to allow Queries to execute faster.
C.
Stop and start the warehouse to clear the queued queries
Answers
C.
Stop and start the warehouse to clear the queued queries
D.
Migrate some queries to a new warehouse to reduce load
Answers
D.
Migrate some queries to a new warehouse to reduce load
E.
Limit user access to the warehouse so fewer queries are run against it.
Answers
E.
Limit user access to the warehouse so fewer queries are run against it.
Suggested answer: A, D
asked 23/09/2024
Louis Reeves
44 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first