SnowPro Core Certification — Question 640

Which type of join will list all rows in the specified table, even if those rows have no match in the other table?

Answer options

• A. Cross join
• B. Inner join
• C. Natural join
• D. Outer join

Correct answer: D

Explanation

The correct answer is D, Outer join, as it ensures that all rows from the specified table are included regardless of matches in the other table. Options A, B, and C do not provide this guarantee; for example, Inner join only includes rows with matching values in both tables.