CompTIA Data+ (DA0-001) — Question 222

A sales manager requested a report that contains the first name, last name, and phone number of all of the company's customers and employees. The data engineer needs to return all the records from several tables, even duplicates. Which of the following is the best way to join the two tables?

Answer options

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

Correct answer: D

Explanation

The correct answer is D, CROSS JOIN, which allows for every combination of records from both tables, thus including all duplicates. The other options, such as FULL OUTER JOIN and LEFT OUTER JOIN, are not suitable for generating all combinations as they filter results based on matching records, which would omit duplicates.