SnowPro Core Certification — Question 767

What are the recommended steps to address poor SQL query performance due to data spilling? (Choose two.)

Answer options

• A. Clone the base table.
• B. Fetch required attributes only.
• C. Use a larger virtual warehouse.
• D. Process the data in smaller batches.
• E. Add another cluster in the virtual warehouse.

Correct answer: C, D

Explanation

The correct answers, C and D, focus on scaling resources and optimizing data handling to mitigate performance issues. Using a larger virtual warehouse (C) provides more compute power, while processing data in smaller batches (D) reduces memory strain. The other options do not directly address the performance issues related to data spilling.