COF-C02 · Question #316
Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).
The correct answer is C. Bytes spilled to local storage D. Bytes spilled to remote storage. When a Snowflake virtual warehouse processes a query, it attempts to keep intermediate results (e.g., sort buffers, hash join tables) in memory. If the data volume exceeds available memory, Snowflake 'spills' the overflow data: first to the local SSD disk of the warehouse node…
Question
Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).
Options
- ABytes scanned
- BPartitions scanned
- CBytes spilled to local storage
- DBytes spilled to remote storage
- EPercentage scanned from cache
How the community answered
(31 responses)- A3% (1)
- B3% (1)
- C94% (29)
Explanation
When a Snowflake virtual warehouse processes a query, it attempts to keep intermediate results (e.g., sort buffers, hash join tables) in memory. If the data volume exceeds available memory, Snowflake 'spills' the overflow data: first to the local SSD disk of the warehouse node (Bytes spilled to local storage - C), and if that is also insufficient, to remote cloud object storage (Bytes spilled to remote storage - D). Both metrics appearing in Query Profile are strong indicators of a memory pressure problem and typically signal that a larger warehouse size is needed, or that the query should be rewritten to reduce intermediate data size.
Topics
Community Discussion
No community discussion yet for this question.