DatabricksCertified Data Engineer Associate
Domain 3Objective 2
Combine DataFrames with Operations Such as Inner Join, Left Join, Broadcast Join, Multiple Keys, Cross Join, Union, and Union All. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 2)
Part of the Data Transformation and Modeling domain, which accounts for 22% of the DATA-ENGINEER-ASSOCIATE exam. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–13 in this domain), expect 1–2 from this objective — we provide 13 practice questions to prepare you well beyond it. (estimate)
13questions here
3free pages
7concepts
22%of the exam
Questions 6–10
- 6
Which join type preserves all rows from the left DataFrame and fills columns from the right DataFrame with nulls when there is no match?
Select an answer first - 7
You have a DataFrame with 3 rows and another with 4 rows. How many rows will a cross join produce?
Select an answer first - 8
How do you specify multiple join keys in a Spark DataFrame join?
Select an answer first - 9
A data scientist has a `products` DataFrame with 10 rows and a `promotions` DataFrame with 5 rows. They want to create a DataFrame that contains every possible combination of a product and a promotion to analyze which promotions could apply to which products. There is no natural key to join on. Which operation should they use?
Select an answer first - 10
Which operation concatenates two DataFrames with identical schemas and preserves all rows, including duplicates?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ENGINEER-ASSOCIATE” is a trademark of its owner, used for identification only.