Answer-first summary for fast verification
Answer: The warehouse memory is not sufficient to hold the intermediate query results.
The query profile showing data spilling to disk indicates insufficient warehouse memory to hold intermediate query results. When Snowflake's compute resources lack sufficient memory for operations like large sorts, joins, or aggregations, it spills data first to local disk and then to remote disk if needed, causing performance degradation. Option D directly addresses this memory limitation scenario. Option A is incorrect as the result cache stores final query results, not intermediate results. Option B is unrelated as cloud storage staging handles data loading/unloading, not query processing. Option C is misleading - while clustering can improve query performance, lack of clustering doesn't directly cause disk spilling; insufficient memory does.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A user observes that a query in Snowflake is experiencing prolonged execution time. The query profile indicates significant data spilling to local disk.
What is the most likely cause of this performance issue?
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.
No comments yet.