
Explanation:
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.
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.