Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
Question 19
A data engineer wants to horizontally combine two tables as a part of a query. They want to use a shared column as a key column, and they only want the query result to contain rows whose value in the key column is present in both tables.
Which of the following SQL commands can they use to accomplish this task?
Real Exam
Community
LLeetQuiz
A
INNER JOIN
B
OUTER JOIN
C
LEFT JOIN
D
MERGE
E
UNION
Explanation:
Explanation
An INNER JOIN is the correct SQL command for this scenario because:
- INNER JOIN returns only the rows that have matching values in both tables based on the specified key column
- It horizontally combines tables (side-by-side) using a shared column as the join key
- It filters out rows where the key column value exists in only one table
- Only rows with matching key values in both tables are included in the result
Why other options are incorrect:
- OUTER JOIN (B): Returns all rows from both tables, including non-matching rows (fills with NULLs)
- LEFT JOIN (C): Returns all rows from the left table and matching rows from the right table
- MERGE (D): Used for upsert operations (update/insert), not for horizontal table combination in queries
- UNION (E): Vertically combines tables (stacking rows), not horizontally combining columns
The key requirements in the question are:
- Horizontal combination of tables
- Using a shared column as key
- Only rows with matching key values in both tables
- INNER JOIN perfectly satisfies all these requirements.
Comments
Loading comments...