SnowPro Core Certification — Question 861

What step can reduce data spilling in Snowflake?

Answer options

• A. Using a larger virtual warehouse
• B. Increasing the virtual warehouse maximum timeout limit
• C. Increasing the amount of remote storage for the virtual warehouse
• D. Using a Common Table Expression (CTE) instead of a temporary table

Correct answer: A

Explanation

Choosing a larger virtual warehouse increases computational resources, which can handle more data in memory, reducing the likelihood of data spilling. The other options do not directly address the root cause of data spilling; for example, increasing timeout limits or storage does not improve processing capacity, and using CTEs instead of temporary tables does not necessarily affect data spilling.