SnowPro Core Certification — Question 962

What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?

Answer options

• A. IO
• B. Network
• C. Pruning
• D. Spilling

Correct answer: D

Explanation

The correct answer is D, Spilling, which refers to writing intermediate results to disk when memory is insufficient. Options A (IO), B (Network), and C (Pruning) do not specifically indicate disk usage for intermediate results and are related to other aspects of query execution.