Question 60
A Python Snowpark workload needs far more memory for large in-memory operations than an ordinary SQL warehouse offers. Which warehouse type should be evaluated?
Explanation
Correct Answer
Correct—this case calls for extra per-node memory for Snowpark processing. Snowpark-optimized warehouse provides larger memory per compute node for memory-intensive Snowpark workloads.
Incorrect Answers
Incorrect here—Standard virtual warehouse executes ordinary SQL and Snowpark workloads on standard compute, whereas the stated requirement is extra per-node memory for Snowpark processing.
Incorrect here—Multi-cluster warehouse adds warehouse clusters primarily to scale query concurrency, whereas the stated requirement is extra per-node memory for Snowpark processing.
Incorrect here—Query Acceleration Service can offload eligible query work to serverless compute to improve query performance, whereas the stated requirement is extra per-node memory for Snowpark processing.