Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What occurs when a virtual warehouse in Snowflake 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.
