COF-C02 · Question #559
COF-C02 Question #559: Real Exam Question with Answer & Explanation
The correct answer is D: The additional compute resources are provisioned when the warehouse is resumed.. In Snowflake, resizing a virtual warehouse that is currently suspended does not immediately provision the new compute resources. Instead, the change in size is recorded, and the additional compute resources are provisioned when the warehouse is resumed. This means that the action
Question
What happens when a suspended virtual warehouse is resized in Snowflake?
Options
- AIt will return an error.
- BIt will return a warning.
- CThe suspended warehouse is resumed and new compute resources are provisioned immediately.
- DThe additional compute resources are provisioned when the warehouse is resumed.
Explanation
In Snowflake, resizing a virtual warehouse that is currently suspended does not immediately provision the new compute resources. Instead, the change in size is recorded, and the additional compute resources are provisioned when the warehouse is resumed. This means that the action of resizing a suspended warehouse does not cause it to resume operation automatically. The warehouse remains suspended until an explicit command to resume it is issued, or until it automatically resumes upon the next query execution that requires it. This behavior allows for efficient management of compute resources, ensuring that credits are not consumed by a warehouse that is not in use, even if its size is adjusted while it is suspended.
Topics
Community Discussion
No community discussion yet for this question.