Databricks Certified Data Analyst Associate · Free Practice Question Easy
Question 1
Consider the following two tables, employees and departments:
employees Table:
departments Table:
An analyst performed a SQL JOIN operation to create the following result table:
Result Table:
Which type of JOIN was used to create this result table?
-
A
RIGHT
-
B
LEFT
-
C
INNER
-
D
FULL OUTER
-
E
CROSS
Reveal correct answer
Correct answer: B
Explanation
The correct answer is a LEFT JOIN. In a LEFT JOIN, all rows from the left table (employees) are included in the result, along with matching rows from the right table (departments). If there is no match, NULL values are returned for columns from the right table. This explains why David appears in the result with NULL for department_name.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
