SnowPro Core Certification — Question 508

Which use case will always cause an exploding join in Snowflake?

Answer options

• A. A query that has more than 10 left outer joins.
• B. A query that is using a UNION without an ALL.
• C. A query that has not specified join criteria for tables.
• D. A query that has requested too many columns of data.

Correct answer: C

Explanation

The correct answer is C because failing to specify join criteria means that the database will create a Cartesian product, leading to an explosion of rows. Options A, B, and D may lead to performance issues but do not inherently cause an exploding join as they can still have defined relationships or criteria.