SnowPro Advanced: Architect — Question 126

What symptom of a join explosion is identified in the Query Profile?

Answer options

• A. The number of rows output from a join operator is significantly more than the number of rows it consumed.
• B. The join completes in under 1% of the execution time.
• C. There is no join filter below the exploding join.
• D. The number of result rows is less than the number of rows output from the exploding join.

Correct answer: A

Explanation

The correct answer, A, indicates that a join explosion occurs when the output rows from a join operator greatly exceed the input rows, suggesting an inefficient join operation. Options B and C do not directly indicate a join explosion, while D contradicts the definition, as it suggests fewer output rows than expected.