COF-C02 · Question #598
Which type of workload is recommended for Snowpark-optimized virtual warehouses?
The correct answer is B. Workloads that have large memory requirements. Snowpark-optimized warehouses provide significantly more memory per compute node (up to 16x more than standard warehouses), making them ideal for memory-intensive workloads such as training machine learning models, large-scale data transformations using Snowpark DataFrames, or…
Question
Which type of workload is recommended for Snowpark-optimized virtual warehouses?
Options
- AWorkloads with ad hoc analytics
- BWorkloads that have large memory requirements
- CWorkloads with unpredictable data volumes for each query
- DWorkloads that are queried with small table scans and selective filters
How the community answered
(41 responses)- A7% (3)
- B88% (36)
- C2% (1)
- D2% (1)
Explanation
Snowpark-optimized warehouses provide significantly more memory per compute node (up to 16x more than standard warehouses), making them ideal for memory-intensive workloads such as training machine learning models, large-scale data transformations using Snowpark DataFrames, or executing UDFs that process large datasets. Ad hoc analytics (A), unpredictable data volumes (C), and small table scans with selective filters (D) are typical candidates for standard virtual warehouses and do not require the elevated memory profile.
Topics
Community Discussion
No community discussion yet for this question.