SNOWPRO-CORE practice question 21 of 35
True or False: A Virtual Warehouse can be resized while suspended.
Full set: 628 questionsDomain Virtual Warehouses
A virtual warehouse in Snowflake can be resized at any time, regardless of its current state. When a resize operation is performed on a suspended warehouse, the change is made to the warehouse's metadata immediately. The new size will then be provisioned and take effect the next time the warehouse is resumed to execute a query or other workload. This allows administrators to adjust compute resources proactively without needing to first start the warehouse.
The "False" option is incorrect because it wrongly assumes that a warehouse must be in an active or running state to have its properties modified. Snowflake's architecture decouples the warehouse's configuration (a metadata object) from its provisioned compute resources. Therefore, altering the configuration, such as its size, is a metadata operation that can be performed even when the compute resources are deprovisioned (i.e., the warehouse is suspended).
1. Snowflake Documentation: Resizing a Warehouse.
Section: Overview of Warehouses
Quote: "A warehouse can be resized at any time, including while it is running and processing statements." The phrase "at any time" explicitly includes the suspended state. The change is applied to subsequent queries after any currently running queries complete and the new resources are provisioned. For a suspended warehouse, this means the new size is used upon its next resume.
2. Snowflake Documentation: ALTER WAREHOUSE.
Section: Usage Notes
Quote: "When the size is changed, the change does not affect any statements, including queries, that are currently executing. Once the statements complete and the compute resources are fully provisioned, the new size is used for all subsequent statements." This confirms that resizing is a configuration change that takes effect when compute resources are provisioned, which for a suspended warehouse, occurs at the next resume.
Keep practicing
Take the free SNOWPRO-CORE practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SNOWPRO-CORE practice questions
- Question 1How long does Snowflake retain information in the ACCESS HISTORY view?
- Question 2While working with unstructured data, which file function generates a Snowflake-hosted fi…
- Question 3Which Snowflake table supports unstructured data?
- Question 4When using the ALLOW_CLI£NT_MFA_CACHING parameter, how long is a cached Multi-Factor Auth…
- Question 5What feature of Snowflake Continuous Data Protection can be used for maintenance of histo…
- Question 6Which Snowflake edition enables data sharing only through Snowflake Support?
