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

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
A . A single join node uses more than 50% of the query time
B . Partitions scanned is equal to partitions total
C . An AggregateOperacor node is present
D . The query is spilling to remote storage

View Answer

Answer: D

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 required.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Query Profile1

Snowpro Core Certification Exam Flashcards2