CompTIA DataX (DY0-001) — Question 28

Which of the following JOINS would generate the largest amount of data?

Answer options

• A. RIGHT JOIN
• B. LEFT JOIN
• C. CROSS JOIN
• D. INNER JOIN

Correct answer: C

Explanation

The CROSS JOIN produces the largest amount of data because it combines every row from one table with every row from another, resulting in a Cartesian product. In contrast, the INNER JOIN, LEFT JOIN, and RIGHT JOIN only combine rows based on matching conditions, leading to a smaller dataset.