What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

The correct answer is B. Warehouses can be started and stopped at any time. C. Warehouses can be resized at any time, even while running. Snowflake virtual warehouses are highly flexible compute clusters. They can be started and stopped on demand - when stopped, they consume no credits. They can also be resized (e.g., from Small to Large) at any time, including while queries are actively running; the resize…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

AWarehouses that are multi-cluster can have nodes of different sizes.
BWarehouses can be started and stopped at any time.
CWarehouses can be resized at any time, even while running.
DWarehouses are billed on a per-minute usage basis.
EWarehouses can only be used for querying and cannot be used for data loading.

How the community answered

(35 responses)

A
6% (2)
B
89% (31)
D
3% (1)
E
3% (1)

Explanation

Snowflake virtual warehouses are highly flexible compute clusters. They can be started and stopped on demand - when stopped, they consume no credits. They can also be resized (e.g., from Small to Large) at any time, including while queries are actively running; the resize applies to subsequent queries. Option A is false because multi-cluster warehouses require all nodes to be the same warehouse size - mixed node sizes are not supported. Option D is misleading: Snowflake bills per-second (with a 60-second minimum), not strictly per-minute. Option E is false because virtual warehouses are used for both querying and data loading (COPY INTO operations).

Topics

#virtual warehouses#compute elasticity#dynamic scaling#resource management

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice