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

exams COF-R02 COF-R02 exam 0 Comments

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

Answer: D