
Answer-first summary for fast verification
Answer: Spilling
The question asks about the term used when intermediate results cannot fit in a Snowflake virtual warehouse's memory and must use disk storage. 'Spilling' is the correct term in Snowflake terminology, referring to the process where data spills from memory to local disk when memory capacity is exceeded during query processing. The community discussion shows 100% consensus on answer B (Spilling) with upvoted comments confirming this is correct. Other options are not relevant: 'Pruning' refers to eliminating unnecessary data partitions, 'Join explosion' describes inefficient join operations, and 'Queue overloading' is not a standard Snowflake term for disk usage scenarios.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.