A virtual warehouse’s auto-suspend and auto-resume settings apply to which of the following?

A virtual warehouse’s auto-suspend and auto-resume settings apply to which of the following?
A . The primary cluster in the virtual warehouse
B . The entire virtual warehouse
C . The database in which the virtual warehouse resides
D . The Queries currently being run on the virtual warehouse

View Answer

Answer: B

Explanation:

The auto-suspend and auto-resume settings in Snowflake apply to the entire virtual warehouse. These settings allow the warehouse to automatically suspend when it’s not in use, helping to save on compute costs. When queries or tasks are submitted to the warehouse, it can automatically resume operation. This functionality is designed to optimize resource usage and cost-efficiency.

Reference: SnowPro Core Certification Exam Study Guide (as of 2021)

Snowflake documentation on virtual warehouses and their settings (as of 2021)