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.