Answer: Workloads that have large memory requirements

According to Snowflake's official documentation referenced in the community discussion, Snowpark-optimized warehouses are specifically designed for workloads with large memory requirements. These warehouses provide more memory per node compared to standard warehouses, making them ideal for memory-intensive operations common in Snowpark workloads such as machine learning, data processing with large datasets, and complex transformations. Option B directly aligns with the documented use case. The other options are less suitable: A (ad hoc analytics) typically uses standard warehouses, C (unpredictable data volumes) may benefit from auto-scaling features available in standard warehouses, and D (small table scans with selective filters) doesn't require the enhanced memory capabilities of Snowpark-optimized warehouses.

Author: LeetQuiz Editorial Team