nerdexam
Snowflake

COF-C02 · Question #590

What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?

The correct answer is B. Small. Snowpark-optimized warehouses are specialized virtual warehouses designed for memory-intensive Snowpark workloads (e.g., ML training, large DataFrame operations). Unlike standard warehouses that start at X-Small, Snowpark-optimized warehouses have a minimum size requirement of…

Snowflake Cloud Data Platform Features and Architecture

Question

What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?

Options

  • AX-Small
  • BSmall
  • CMedium
  • DLarge

How the community answered

(38 responses)
  • A
    3% (1)
  • B
    89% (34)
  • C
    5% (2)
  • D
    3% (1)

Explanation

Snowpark-optimized warehouses are specialized virtual warehouses designed for memory-intensive Snowpark workloads (e.g., ML training, large DataFrame operations). Unlike standard warehouses that start at X-Small, Snowpark-optimized warehouses have a minimum size requirement of Small. This minimum exists because Snowpark workloads require significantly more memory per node - each node in a Snowpark-optimized warehouse provides ~16x more memory than the equivalent standard warehouse node. X-Small is not supported for this warehouse type due to insufficient memory resources.

Topics

#Snowpark-optimized warehouse#Virtual warehouse#Warehouse sizing

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice