Which use case will always cause an exploding join in Snowflake?
Which use case will always cause an exploding join in Snowflake?
A query that has not specified join criteria for tables will always cause an exploding join in Snowflake. This happens because the lack of join criteria results in a Cartesian product, where each row from one table is joined with every row from the other table, leading to a potentially enormous result set.
C. A query that has not specified join criteria for tables.
https://docs.snowflake.com/en/user-guide/ui-snowsight-activity#label-exploding-join C is right option
C https://select.dev/posts/snowflake-query-profile
C. A query that has not specified join criteria for tables
C, other may cause issues but also may work correctly
C Correct, It's also called cartesian product
Answer is C
A&C - both should