Câu 38: DY0-001: CompTIA DataX

A data scientist is merging two tables. Table 1 contains employee IDs and roles. Table 2 contains employee IDs and team assignments. Which of the following is the best technique to combine these data sets?

1. A. INNER JOIN between Table 1 and Table 2 — đáp án hiện tại
2. B. LEFT JOIN on Table 1 with Table 2
3. C. RIGHT JOIN on Table 1 with Table 2
4. D. OUTER JOIN between Table 1 and Table 2