Answer-first summary for fast verification
Answer: Warehouses can be started and stopped at any time., Warehouses can be resized at any time, even while running.
The question asks for two key characteristics of virtual warehouses in Snowflake. Option B is correct because warehouses can be started and stopped at any time, providing flexibility in resource management. Option C is correct because warehouses can be resized at any time, even while running, allowing for dynamic scaling without interrupting operations. Option A is incorrect because multi-cluster warehouses must have nodes of the same size. Option D is incorrect because warehouses are billed on a per-second basis, not per-minute. Option E is incorrect because warehouses can be used for both querying and data loading operations. The community discussion with 100% consensus and upvoted comments confirms BC as the correct answer.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are key characteristics of virtual warehouses in Snowflake? (Choose two.)
A
Warehouses that are multi-cluster can have nodes of different sizes.
B
Warehouses can be started and stopped at any time.
C
Warehouses can be resized at any time, even while running.
D
Warehouses are billed on a per-minute usage basis.
E
Warehouses can only be used for querying and cannot be used for data loading.
No comments yet.