Answer: Medium

The correct answer is C (Medium) based on Snowflake's official documentation for Snowpark-optimized warehouses. While some community members initially selected A (X-Small) based on testing or partial information, the official documentation clearly states that Snowpark-optimized warehouses are only available in Medium, Large, X-Large, 2X-Large, 3X-Large, and 4X-Large sizes, with Medium being the minimum. The community discussion shows that answers citing the official documentation (C) received higher upvotes (4 and 2) compared to answers based on personal testing (A with 1 and 2 upvotes), indicating stronger consensus around the documented requirement. Snowpark-optimized warehouses are specifically designed for memory-intensive workloads and require larger compute resources than standard warehouses, which is why X-Small and Small are not available options.

Author: LeetQuiz Editorial Team