
Answer-first summary for fast verification
Answer: The entire Virtual Warehouse
The auto-suspend and auto-resume settings in Snowflake apply to the entire Virtual Warehouse as a single unit. When a Virtual Warehouse is configured with auto-suspend, the entire warehouse will automatically suspend after a specified period of inactivity to save costs. Similarly, auto-resume triggers the entire warehouse to resume when a new query is submitted. These settings do not apply to just the primary cluster (A), as the warehouse operates as a unified resource. They are not tied to the database (C), as warehouses are independent compute resources that can query any database. They also do not apply only to currently running queries (D), as the settings govern the warehouse's overall state management rather than individual query execution.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which of the following do a Virtual Warehouse's auto-suspend and auto-resume settings apply to?
A
The primary cluster in the Virtual Warehouse
B
The entire Virtual Warehouse
C
The database the Virtual Warehouse resides in
D
The queries currently being run by the Virtual Warehouse
No comments yet.