DatabricksCertified Data Analyst Associate
Domain 4Objective 6
Write Queries to Combine Tables Using Various Join Operations (inner, Left, Right, and So on) with Single or Multiple Keys, as Well as Set Operations Like Union and Union All, Including the Differences Between the Joins (inner, Left, Right, and So On). DATA-ANALYST-ASSOCIATE Practice Questions (Page 5)
Part of the Section 4: Executing queries using Databricks SQL and Databricks SQL Warehouses domain, which makes up ~22% of our current practice bank. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–13 in this domain), expect 1–1 from this objective — we provide 28 practice questions to prepare you well beyond it. (estimate)
28questions here
6free pages
15concepts
Questions 21–25
- 21
Which join type returns only rows from the left table that have a match in the right table, without returning any columns from the right table?
Select an answer first - 22
In a `RIGHT JOIN` between `orders` (left) and `customers` (right), what happens to customers who have no orders?
Select an answer first - 23
A data analyst is comparing the results of different joins between the `orders` table (left) and `customers` table (right) on `customer_id`. The analyst notices that one join returns all orders, including those with no matching customer, and also includes NULLs for customer columns when there is no match. Which join type did the analyst use?
Select an answer first - 24
In a `LEFT JOIN` between `employees` (left) and `departments` (right), what will the `department_name` column contain for an employee who is not assigned to any department?
Select an answer first - 25
Which SQL keyword is used to return only rows that have matching values in both tables being joined?
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-ANALYST-ASSOCIATE” is a trademark of its owner, used for identification only.