Home / Data Engineer Associate / Objective 3.2

Domain 3: Data Transformation and Modeling · 22% of the exam · Full exam outline

3.2 Combine DataFrames with operations such as Inner join, left join, broadcast join, multiple keys, cross join, union, and union all.

Practice questions

Question 1easy

A silver job joins customers (left) to orders (right) on customer_id. The output must list every customer, with the order columns set to NULL for customers who have not ordered yet. Which join type meets this?

Included in Sample: sample every domain.See plans

Choose an answer to check it. Afterward, select any option to review its explanation.

A semi join sounds close because it is driven by the left table, but it returns only left rows that do have a match and no columns from the right side.

An inner join keeps only customers that have a matching order, so customers without orders would disappear.

A cross join pairs every customer with every order, ignoring customer_id entirely.

A left outer join keeps every row of the left table and fills the right-side columns with NULL when no order matches.

Question 2easy

An analyst combines the January and February extracts of a returns table in SQL. Every row must be kept, including rows that appear identically in both months, so totals match the source systems. Which set operator fits?

Included in Master: master every domain.See plans