Answer-first summary for fast verification
Answer: A query that has not specified join criteria for tables.
The correct answer is C because a query that has not specified join criteria for tables will always result in a Cartesian product, where every row from one table is joined with every row from the other table, causing an 'exploding join'. This is explicitly defined in Snowflake documentation and community discussions as the primary cause of exploding joins. Option A (more than 10 left outer joins) may cause performance issues but does not always result in a Cartesian product. Option B (UNION without ALL) removes duplicates but does not inherently cause exploding joins. Option D (requesting too many columns) may impact performance but does not guarantee a Cartesian product. The community discussion strongly supports C with 88% consensus, detailed explanations about Cartesian products, and references to Snowflake documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which scenario will always result in a cartesian product when performing a join in Snowflake?
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.