SnowPro Core Certification — Question 683

Which term is used to describe information about disk usage for operations where intermediate results cannot be accommodated in a Snowflake virtual warehouse memory?

Answer options

• A. Pruning
• B. Spilling
• C. Join explosion
• D. Queue overloading

Correct answer: B

Explanation

The correct answer is B, Spilling, which refers to the process of writing intermediate results to disk when memory limits are exceeded. The other options do not relate to this specific scenario; A, Pruning refers to eliminating unnecessary data, C, Join explosion pertains to excessive intermediate results from joins, and D, Queue overloading, deals with task management rather than disk usage.