SnowPro Core Certification — Question 134

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

Answer options

• A. A single join node uses more than 50% of the query time
• B. Partitions scanned is equal to partitions total
• C. An AggregateOperator node is present
• D. The query is spilling to remote storage

Correct answer: D

Explanation

The correct answer, D, indicates that the query is spilling to remote storage, which happens when it exceeds memory limits. Option A discusses time taken by a join node, which does not directly relate to memory issues. Option B is about the partition scanning and is not a clear sign of memory overflow. Option C mentions an AggregateOperator node, which can be present in various scenarios and does not necessarily imply memory overflow.