nerdexam
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)
  • A
    4% (1)
  • B
    7% (2)
  • C
    11% (3)
  • D
    79% (22)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice