Snowflake
COF-R02 · Question #135
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
The correct answer is D. The query is spilling to remote storage. See the full explanation below for the reasoning.
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
How the community answered
(28 responses)- A4% (1)
- B7% (2)
- C11% (3)
- D79% (22)
Community Discussion
No community discussion yet for this question.