COF-C02 practice question 19 of 35
True or False: A Virtual Warehouse can be resized while suspended.
Full set: 778 questionsA virtual warehouse's properties, including its size, can be modified at any time using the ALTER WAREHOUSE command, regardless of its current state (running, suspended, or resizing). If the warehouse is suspended when it is resized, the new size will be applied when the warehouse is next resumed. This allows administrators to proactively scale resources up or down in anticipation of future workloads without needing to start the warehouse first.
False: This is incorrect. The ALTER WAREHOUSE command is independent of the warehouse's operational state and can be executed on a suspended warehouse.
- Snowflake Documentation: "Resizing a Warehouse". The documentation states, "A warehouse can be resized at any time, including while it is running and processing statements." This implies it can also be altered while suspended.
- Snowflake Documentation: ALTER WAREHOUSE. The "Usage Notes" section confirms properties can be modified at any time. For resizing, it notes, "The new size is used for all subsequent queries," which for a suspended warehouse means upon its next resume.
Keep practicing
Take the free COF-C02 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other COF-C02 practice questions
- Question 1What does Snowflake recommend regarding database object ownership? (Select TWO).
- Question 2What kind of value does a User-Defined Function (UDF) return? (Select TWO).
- Question 3How do Snowflake data providers share data that resides in different databases?
- Question 4What are supported file formats for unloading data from Snowflake? (Choose three.)
- Question 5A marketing co-worker has requested the ability to change a warehouse size on their mediu…
- Question 6What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authe…
