COF-C02 · Question #39
COF-C02 Question #39: Real Exam Question with Answer & Explanation
The correct answer is D: The query is spilling to remote storage. When a query in Snowflake is too large to fit into the available memory, it will start spilling to remote storage. This is an indication that the memory allocated for the query is insufficient for its execution, and as a result, Snowflake uses remote disk storage to handle the ov
Question
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
Options
- AA single join node uses more than 50% of the query time
- BPartitions scanned is equal to partitions total
- CAn AggregateOperacor node is present
- DThe query is spilling to remote storage
Explanation
When a query in Snowflake is too large to fit into the available memory, it will start spilling to remote storage. This is an indication that the memory allocated for the query is insufficient for its execution, and as a result, Snowflake uses remote disk storage to handle the overflow. This spill to remote storage can lead to slower query performance due to the additional I/O operations
Topics
Community Discussion
No community discussion yet for this question.