Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. Discussions
  3. Snowflake
  4. SnowPro Core Certification
  5. COF-C02 Discussions
  6. COF-C02 Exam Topic 19 Question 185 Discussion
 Snowflake Discussions
Exam COF-C02 All Questions
Exam COF-C02 All Questions

View all questions & answers for the COF-C02 exam

Go to Exam

Snowflake SnowPro Core Certification COF-C02 Question # 185 Topic 19 Discussion

COF-C02 Exam Topic 19 Question 185 Discussion:
Question #: 185
Topic #: 19

ION NO: 229

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

Get Premium COF-C02 Questions
Actual exam question for Snowflake COF-C02 exam by Tess32677 at Apr 28, 2026, 5:53:08 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit