SnowPro Core Certification — Question 476

A Query Profile shows a UnionAll operator with an extra Aggregate operator on top.

What does this signify?

Answer options

• A. Exploding joins
• B. Inefficient pruning
• C. UNION without ALL
• D. Queries that are too large to fit in memory

Correct answer: C

Explanation

The presence of a UnionAll operator with an Aggregate operator suggests that the query is performing a UNION operation that includes duplicate results, thus indicating that it is a UNION without ALL. The other options do not accurately describe this scenario as they relate to different issues or behaviors in query execution.