What will happen if a Snowflake user increases the size of a suspended virtual warehouse?

Question

Options

• AThe provisioning of new compute resources for the warehouse will begin immediately.
• BThe warehouse will remain suspended but new resources will be added to the query acceleration
• CThe provisioning of additional compute resources will be in effect when the warehouse is next
• DThe warehouse will resume immediately and start to share the compute load with other running

• A
  7% (3)
• B
  2% (1)
• C
  86% (36)
• D
  5% (2)

Explanation

When a virtual warehouse is resized while in a suspended state, Snowflake records the new size configuration but does not immediately provision any compute resources - the warehouse is still suspended and consuming no credits. The new, larger set of compute resources will be provisioned when the warehouse is next resumed. This differs from resizing a running warehouse, where additional nodes are provisioned immediately and added to the active cluster. Option A is wrong because provisioning does not begin immediately for a suspended warehouse. Options B and D describe behaviors that do not occur in Snowflake.

No community discussion yet for this question.