# Databricks Data Analyst (DDA) practice exams

> Databricks Data Analyst practice exams: 215 questions in 5 timed tests, every answer explained.

Page: https://devopscodelab.com/exams/databricks-data-analyst/

215 questions in 5 timed practice tests. Each test has about 45 questions and a 90-minute limit. The pass mark is 70%. Results are split across the 9 exam domains.

## Exam at a glance

| Setting | Value |
| --- | --- |
| Practice tests | 5 |
| Questions in total | 215 |
| Questions per test | About 45 |
| Time limit per test | 90 minutes |
| Pass mark | 70% |
| Question types | Single answer and multiple answer (20 multiple-answer questions) |
| Level | Associate |
| Category | Data & Analytics |

These are the settings of our practice tests. Check the official Databricks exam page for the current format before you book.

## Domains and weights

| Domain | Weight | Questions in our bank |
| --- | --- | --- |
| Understanding of Databricks Data + AI Platform | 11% | 24 |
| Managing Data | 8% | 17 |
| Importing Data | 5% | 10 |
| Executing Queries Using Databricks SQL and SQL Warehouses | 20% | 43 |
| Analyzing Queries | 15% | 33 |
| Creating Dashboards and Visualizations | 16% | 34 |
| Developing, Sharing, and Maintaining AI/BI Genie Spaces | 12% | 26 |
| Data Modeling with Databricks SQL | 5% | 11 |
| Securing Data | 8% | 17 |

## Price and access

- DDA practice exams: $12.99 for 12 months of access.
- Free mini exam: 15 questions with explanations (free account): https://devopscodelab.com/app/exams/databricks-data-analyst/mini/
- All-Access subscription includes every exam: https://devopscodelab.com/pricing/
- 10 free questions with answers: https://devopscodelab.com/exams/databricks-data-analyst/free-practice-questions/

## Sample questions

### Question 1 of 3

Which component of the Databricks platform provides centralized access control, auditing, lineage and data discovery across all workspaces attached to the same metastore?

- A. Photon
- B. Delta Lake
- C. Databricks Marketplace
- D. Unity Catalog

**Answer:** D

**Explanation:** Unity Catalog is the unified governance layer that manages permissions, audit logs, lineage and discovery for data and AI assets across workspaces sharing a metastore. Delta Lake is the open table format that provides ACID transactions and time travel on storage. Photon is the vectorized query engine that speeds up execution. Databricks Marketplace is an exchange for finding and sharing datasets and other data products.

### Question 2 of 3

An analyst runs VACUUM with the default retention on a Delta table, then tries to query a version from three weeks ago with VERSION AS OF and gets an error. What explains this?

- A. VACUUM compacted small files into larger ones, so the old version's file names no longer match the log
- B. VACUUM removed the data files that the old version referenced because they were older than the retention threshold
- C. VACUUM rewrote the transaction log into a single checkpoint file, so all earlier version numbers were renumbered
- D. VACUUM converted the table to an external table, and external tables do not support time travel queries

**Answer:** B

**Explanation:** VACUUM permanently deletes data files no longer referenced by the current table version and older than the retention threshold (seven days by default), so time travel to versions that need those files fails. VACUUM does not renumber versions or rewrite the log into a checkpoint. It does not change a table from managed to external. Compaction is done by OPTIMIZE, and it keeps old files until they are vacuumed.

### Question 3 of 3

New CSV files land daily in a Unity Catalog volume. An analyst wants a SQL statement that loads only files not loaded before into an existing Delta table, so rerunning it does not create duplicates. Which statement fits?

- A. MERGE INTO the table from a temporary view of the path
- B. INSERT INTO ... SELECT * FROM read_files on the path
- C. CREATE OR REPLACE TABLE ... AS SELECT from the path
- D. COPY INTO with the volume path and FILEFORMAT = CSV

**Answer:** D

**Explanation:** COPY INTO tracks which files it has already loaded and skips them on rerun, making incremental, idempotent loads from a path simple. INSERT ... SELECT from read_files reads all files every time and duplicates rows on rerun. CREATE OR REPLACE TABLE rebuilds the whole table rather than appending new files. A MERGE from all files could deduplicate on keys but reads everything each time and needs a key, which is more complex.


## Study plans

### Two weeks

1. Day 1: take practice test 1 in exam mode to get a baseline.
2. Days 2 to 5: domain mode on Executing Queries Using Databricks SQL and SQL Warehouses and Creating Dashboards and Visualizations, the two most heavily weighted domains.
3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

### Four weeks

1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

## Questions about the DDA practice exams

**Are these real DDA exam questions?**

No. We write every question ourselves and map it to the published DDA exam objectives. We do not use leaked or recalled questions.

**Do the time limit and pass mark match the official exam?**

They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.

**Can I try it before I pay?**

Yes. The free mini exam has 15 questions with full explanations and needs no account.

**How long do I keep access?**

A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.

**What happens after I finish a test?**

You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026.

DevOpsCode Lab is not affiliated with Databricks. DDA and related names are trademarks of their owners. We write every question ourselves; these are not real exam questions.
