
Answer-first summary for fast verification
Answer: Spilling
The question asks which metric in a Query Profile indicates disk usage when intermediate results exceed memory capacity. Option D (Spilling) is correct because it specifically refers to the process where data that cannot fit in memory is written to disk. This is confirmed by the community discussion where multiple users affirm D as the correct answer, with one providing a reference to Snowflake documentation about performance impact from disk spilling. The other options are incorrect: A (IO) is too broad and includes both memory and disk operations, B (Network) relates to data transfer between nodes, and C (Pruning) refers to data elimination techniques like partition pruning.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.