In a `FULL OUTER JOIN` between `students` and `enrollments`, which rows will appear in the result?

All students and all enrollments, with NULLs where there is no match

Only enrollments that have no matching student

All students and only enrollments that match

Only students who have enrollments

What happens if you use UNION on two SELECT statements where the first returns two columns and the second returns three columns?

The query runs and returns two columns.

The query returns NULL for the missing column.

The query runs and returns three columns.

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 2)

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 6–10

6foundation · easy
Which join type returns all rows from the left table and only matching rows from the right table, filling non-matches with NULLs?
Select an answer first
7foundation · easy
In a `FULL OUTER JOIN` between `students` and `enrollments`, which rows will appear in the result?
Select an answer first
8foundation · easy
If table A has 3 rows and table B has 4 rows, how many rows will a `CROSS JOIN` between them return?
Select an answer first
9foundation · easy
What happens if you use UNION on two SELECT statements where the first returns two columns and the second returns three columns?
Select an answer first
10application · medium
A sales analyst needs a report listing every customer from the `customers` table, along with their most recent order date from the `orders` table. Some customers have never placed an order and must still appear in the report. Which join type should the analyst use?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ANALYST-ASSOCIATE

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.

Questions 6–10

Which join type returns all rows from the left table and only matching rows from the right table, filling non-matches with NULLs?

In a `FULL OUTER JOIN` between `students` and `enrollments`, which rows will appear in the result?

If table A has 3 rows and table B has 4 rows, how many rows will a `CROSS JOIN` between them return?

What happens if you use UNION on two SELECT statements where the first returns two columns and the second returns three columns?

A sales analyst needs a report listing every customer from the `customers` table, along with their most recent order date from the `orders` table. Some customers have never placed an order and must still appear in the report. Which join type should the analyst use?

Keep studying — Section 4: Executing queries using Databricks SQL and Databricks SQL Warehouses