Question 490
Consider this Snowflake situation: An analytic query spills a large volume of intermediate data to remote storage during a memory-heavy sort. Which platform behavior BEST explains the appropriate solution?
Explanation
Correct Answer
The decisive Snowflake behavior is: Excess intermediate data can exceed available warehouse memory and spill to remote storage. It supports the response: Use Query Profile to confirm spill pressure and benchmark an appropriately larger warehouse or SQL rewrite. Confirm it with this observable result: A repeatable benchmark shows reduced remote spilling and an acceptable cost-performance tradeoff. Distinguish this mechanism from superficially related Snowflake features.
Incorrect Answers
This principle describes a separate cause: Changing multiple independent performance controls at once obscures the actual causal improvement. The reported condition is governed by: Excess intermediate data can exceed available warehouse memory and spill to remote storage. The two mechanisms should not be conflated.
Manual warehouse resizing changes configured compute resources until they are changed again. That explanation applies to a different technical failure. Here the controlling principle is: Excess intermediate data can exceed available warehouse memory and spill to remote storage.
The offered statement is true for this other mechanism: User-defined functions can package reusable expressions without requiring a stored procedure workflow. It does not explain the facts described here, which follow from: Excess intermediate data can exceed available warehouse memory and spill to remote storage.