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

exams COF-C02 V3 COF-C02 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 Aggregate Operacor node is present
D. The query is spilling to remote storage

Answer: D