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…

The correct answer is A. inner join between Table 1 and Table 2. An INNER JOIN merges records only where the employee ID exists in both tables, yielding a single combined table of each employee's role paired with their team assignment.

Data Processing Technologies

Question

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?

Options

Ainner join between Table 1 and Table 2
Bleft join on Table 1 with Table 2
Cright join on Table 1 with Table 2
Douter join between Table 1 and Table 2

How the community answered

(54 responses)

A
76% (41)
B
7% (4)
C
4% (2)
D
13% (7)

Explanation

An INNER JOIN merges records only where the employee ID exists in both tables, yielding a single combined table of each employee's role paired with their team assignment.

Topics

#inner join#SQL joins#data merging#relational data

Community Discussion

No community discussion yet for this question.

Full DY0-001 Practice