SnowPro Core Certification — Question 817
What are key characteristics of virtual warehouses in Snowflake? (Choose two.)
Answer options
- 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.
Correct answer: B, C
Explanation
The correct answers, B and C, highlight the flexibility of virtual warehouses in Snowflake, as they can be started, stopped, and resized at any time, including during operation. Options A and D do not accurately reflect the unique characteristics of Snowflake's warehouses, while option E is incorrect because warehouses can indeed be used for both querying and data loading.