Answer: Use a larger virtual warehouse., Process the data in smaller batches.

The question asks for two recommended steps to address poor SQL query performance caused by data spilling. Based on Snowflake documentation and community consensus, the optimal choices are C (Use a larger virtual warehouse) and D (Process the data in smaller batches). Option C directly increases available memory and local disk space, reducing spilling by providing more resources. Option D mitigates spilling by reducing the data volume processed in each operation, which is explicitly recommended in Snowflake's documentation. While option B (Fetch required attributes only) can help reduce data volume, it is not specifically highlighted as a primary solution for spilling in the referenced documentation. Options A (Clone the base table) and E (Add another cluster in the virtual warehouse) are not directly relevant to resolving spilling issues, as cloning doesn't address resource constraints and adding clusters may not alleviate memory or disk limitations effectively. The community discussion shows strong support for CD (54% of votes), with detailed reasoning from upvoted comments citing official Snowflake guidance.

Author: LeetQuiz Editorial Team