nerdexam
Snowflake

COF-R02 · Question #145

What happens when a virtual warehouse is resized?

The correct answer is B. When reducing the size of a warehouse the compute resources are removed only when they are. See the full explanation below for the reasoning.

Question

What happens when a virtual warehouse is resized?

Options

  • AWhen increasing the size of an active warehouse the compute resource for all running and queued
  • BWhen reducing the size of a warehouse the compute resources are removed only when they are
  • CThe warehouse will be suspended while the new compute resource is provisioned and will resume
  • DUsers who are trying to use the warehouse will receive an error message until the resizing is

How the community answered

(48 responses)
  • A
    4% (2)
  • B
    81% (39)
  • C
    2% (1)
  • D
    13% (6)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice