COF-C02 · Question #665
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
The correct answer is B. The entire virtual warehouse. Auto-suspend and auto-resume are warehouse-level settings that apply to the entire virtual warehouse. Auto-suspend pauses the whole warehouse after a configured period of inactivity, stopping credit consumption. Auto-resume restarts the entire warehouse automatically when a new…
Question
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Options
- AThe primary cluster in the virtual warehouse
- BThe entire virtual warehouse
- CThe database in which the virtual warehouse resides
- DThe Queries currently being run on the virtual warehouse
How the community answered
(25 responses)- B92% (23)
- C4% (1)
- D4% (1)
Explanation
Auto-suspend and auto-resume are warehouse-level settings that apply to the entire virtual warehouse. Auto-suspend pauses the whole warehouse after a configured period of inactivity, stopping credit consumption. Auto-resume restarts the entire warehouse automatically when a new query is submitted. These settings do not apply to individual clusters within a multi-cluster warehouse, specific databases, or individual queries.
Topics
Community Discussion
No community discussion yet for this question.