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

exams COF-C02 V4 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