SnowPro Core Certification — Question 1046

What is the MOST cost-effective way to resolve memory spillage in a virtual warehouse?

Answer options

• A. Enable automatic clustering.
• B. Enable the query acceleration service.
• C. Enable the search optimization service.
• D. Convert to a Snowpark-optimized warehouse.

Correct answer: D

Explanation

The correct answer is D because converting to a Snowpark-optimized warehouse is designed to handle memory more efficiently, thus reducing spillage. The other options may improve performance but do not specifically target the cost-effectiveness or the memory management aspect needed for resolving spillage.