CompTIA DataX (DY0-001) — Question 47

A data analyst wants to generate the most data using tables from a database. Which of the following is the best way to accomplish this objective?

Answer options

• A. INNER JOIN
• B. LEFT OUTER JOIN
• C. RIGHT OUTER JOIN
• D. FULL OUTER JOIN

Correct answer: D

Explanation

The FULL OUTER JOIN is the best option because it combines all records from both tables, including unmatched rows. In contrast, INNER JOIN only returns matching rows, while LEFT and RIGHT OUTER JOINs only include unmatched rows from one side, resulting in less data being retrieved.