Answer: Convert to a Snowpark-optimized warehouse.

The question asks for the MOST cost-effective way to resolve memory spillage in a virtual warehouse. Memory spillage occurs when a query requires more memory than allocated, leading to disk usage and performance degradation. Option D (Convert to a Snowpark-optimized warehouse) is the correct answer because Snowpark-optimized warehouses are specifically designed for memory-intensive workloads, providing optimized resource allocation for complex data processing and machine learning tasks. This approach is more cost-effective than simply increasing warehouse size, as it efficiently handles memory demands without unnecessary compute scaling. The community discussion strongly supports D, with multiple comments citing Snowflake documentation that confirms switching to a Snowpark-optimized warehouse is cost-effective when additional memory is needed without extra compute. Option B (Enable query acceleration service) was mentioned but is less suitable as it dynamically adds compute resources (CPU and memory), which may not be as cost-effective for pure memory issues. Options A and C are irrelevant to memory spillage resolution.

Author: LeetQuiz Editorial Team