SnowPro Core Certification — Question 221

What happens when a virtual warehouse is resized?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because when you reduce the size of a warehouse, compute resources are only removed after confirming they are no longer in use for current executions. Option A is incorrect as it describes the impact of increasing size rather than reducing it. Option C is wrong since the warehouse does not suspend during a resize, and option D is also incorrect because users do not receive error messages during this process.