Exam SnowPro Core topic 1 question 497 discussion

“Exploding” joins One of the common mistakes SQL users make is joining tables without providing a join condition (resulting in a “Cartesian product”), or providing a condition where records from one table match multiple records from another table. For such queries, the Join operator produces significantly (often by orders of magnitude) more tuples than it consumes.

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

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

A&C - both should

C https://select.dev/posts/snowflake-query-profile