COF-C02 · Question #554
Which virtual warehouse consideration can help lower compute resource credit consumption?
The correct answer is C. Automating the virtual warehouse suspension and resumption settings. Credits are consumed only while a virtual warehouse is running. Automating suspension (via auto-suspend) ensures the warehouse stops consuming credits when idle, and automating resumption (via auto-resume) ensures it restarts automatically when needed. This directly minimizes…
Question
Which virtual warehouse consideration can help lower compute resource credit consumption?
Options
- ASetting up a multi-cluster virtual warehouse
- BResizing the virtual warehouse to a larger size
- CAutomating the virtual warehouse suspension and resumption settings
- DIncreasing the maximum cluster count parameter for a multi-cluster virtual warehouse
How the community answered
(65 responses)- A3% (2)
- B6% (4)
- C89% (58)
- D2% (1)
Explanation
Credits are consumed only while a virtual warehouse is running. Automating suspension (via auto-suspend) ensures the warehouse stops consuming credits when idle, and automating resumption (via auto-resume) ensures it restarts automatically when needed. This directly minimizes wasted compute spend. Resizing to a larger size increases credit consumption per minute. Setting up or expanding a multi-cluster warehouse adds more clusters, which also increases overall credit usage rather than reducing it.
Topics
Community Discussion
No community discussion yet for this question.