SnowPro Core Certification — Question 350

A Snowflake user has a query that is running for a long time. When the user opens the query profiler, it indicates that a lot of data is spilling to disk.

What is causing this to happen?

Answer options

• A. The result cache is almost full and is unable to hold the results.
• B. The cloud storage staging area is not sufficient to hold the data results.
• C. Clustering has not been applied to the table so the table is not optimized.
• D. The warehouse memory is not sufficient to hold the intermediate query results.

Correct answer: D

Explanation

The correct answer is D because insufficient warehouse memory means that intermediate query results cannot be held in memory, causing data to spill to disk. Options A and B refer to caching and staging issues, which are not directly related to the query's performance in terms of memory. Option C addresses optimization but does not directly explain the memory-related problem.