Exam COF-C03 Topic 1 Question 196 Discussion

Actual exam question for Snowflake's COF-C03 exam
Question #: 196
Topic #: 1

What happens when a virtual warehouse is resized?

A. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements. C. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete. D. Users who are trying to use the warehouse will receive an error message until the resizing is complete

Suggested Answer: A Vote an answer

When a virtual warehouse in Snowflake is resized, specifically when it is increased in size, the additional compute resources become immediately available to all running and queued queries. This means that the performance of these queries can improve due to the increased resources.Conversely, when the size of a warehouse is reduced, the compute resources are not removed until they are no longer being used by any current operations1.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Virtual Warehouses2

by Nicholas at May 17, 2026, 06:32 AM

Limited Time Offer

15%

Off

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

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business