ExamGecko
Question list
Search
Search

Question 300 - COF-C02 discussion

Report
Export

When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

A.
When users will be using compute at different times throughout a 24/7 period
Answers
A.
When users will be using compute at different times throughout a 24/7 period
B.
When managing a steady workload
Answers
B.
When managing a steady workload
C.
When the compute must be available with no delay or lag time
Answers
C.
When the compute must be available with no delay or lag time
D.
When the user does not want to have to manually turn on the warehouse each time it is needed
Answers
D.
When the user does not want to have to manually turn on the warehouse each time it is needed
E.
When the warehouse is shared across different teams
Answers
E.
When the warehouse is shared across different teams
Suggested answer: B, C

Explanation:

Disabling auto-suspend for a virtual warehouse is recommended when there is a steady workload, which ensures that compute resources are always available.Additionally, it is advisable to disable auto-suspend when immediate availability of compute resources is critical, eliminating any startup delay

asked 23/09/2024
Pavol Adamcin
35 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first