Snowflake SnowPro Certification Practice Test

Can the auto-suspension limits for Virtual Warehouses be changed after initial configuration?

1. Yes

2. No

3. Only by an Account Administrator

4. Only with a new warehouse setup

The correct answer is: Yes

The ability to change the auto-suspension limits for Virtual Warehouses after initial configuration is indeed possible. Snowflake allows for modifications to be made to various settings of a Virtual Warehouse, including the auto-suspension time. This can be done for optimizing costs and performance based on usage patterns or changing requirements. Adjusting the auto-suspension limits provides flexibility to manage resources effectively. This option allows users to ensure that warehouses automatically suspend when not in use, thus reducing resource consumption and costs, while also enabling them to cater to specific performance needs by extending or shortening the auto-suspension timer as required. While other options may refer to restrictions or specific roles that manage accounts, the fundamental capability of changing auto-suspension limits remains accessible and does not necessitate creating a new warehouse or being limited strictly to an account administrator.