Exam COF-C03 Topic 1 Question 356 Discussion

Actual exam question for Snowflake's COF-C03 exam
Question #: 356
Topic #: 1
What happens when a suspended virtual warehouse is resized in Snowflake?

Suggested Answer: D Vote an answer

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.
Reference: Snowflake Documentation on Resizing Warehouses (https://docs.snowflake.com/en/user-guide
/warehouses-tasks.html#resizing-a-warehouse)

by Sigrid at Sep 11, 2026, 05:56 PM

Limited Time Offer

15%

Off

Get Premium COF-C03 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10