DDA

Databricks Data Analyst (DDA) practice exams

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

DDA practice exam settings
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 exam format before you book.

Domains and weights

DDA exam domains, weights and question counts
Domain Weight Weight bar 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

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?

  1. A Photon
  2. B Delta Lake
  3. C Databricks Marketplace
  4. D Unity Catalog (correct answer)
Why: 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?

  1. A VACUUM compacted small files into larger ones, so the old version's file names no longer match the log
  2. B VACUUM removed the data files that the old version referenced because they were older than the retention threshold (correct answer)
  3. C VACUUM rewrote the transaction log into a single checkpoint file, so all earlier version numbers were renumbered
  4. D VACUUM converted the table to an external table, and external tables do not support time travel queries
Why: 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?

  1. A MERGE INTO the table from a temporary view of the path
  2. B INSERT INTO ... SELECT * FROM read_files on the path
  3. C CREATE OR REPLACE TABLE ... AS SELECT from the path
  4. D COPY INTO with the volume path and FILEFORMAT = CSV (correct answer)
Why: 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.

What your score report looks like

Example attempt, DDA practice test 3

74%

Passed
Pass mark 70%

Score by exam domain
DomainWeightYour score%
Understanding of Databricks Data + AI Platform 11%
88
Managing Data 8%
81
Importing Data 5%
76
Executing Queries Using Databricks SQL and SQL Warehouses 20%
58
Analyzing Queries 15%
84
Creating Dashboards and Visualizations 16%
72

Study next: Executing Queries Using Databricks SQL and SQL Warehouses. It is below the pass mark and carries 20% of the exam.

Domains and pass mark from our DDA practice tests. Scores are an example attempt.

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. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Databricks. DDA and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
DCDEPDatabricks Certified Data Engineer Pro Databricks Professional 300 120 $14.99
DMLPDatabricks Machine Learning Professional Databricks Professional 300 120 $14.99
DASDDatabricks Apache Spark Developer Databricks Associate 225 90 $12.99
DCEADatabricks Context Engineer Associate Databricks Associate 225 90 $12.99
DP-900Azure Data Fundamentals DP-900 Microsoft Foundational 225 45 $9.99
SPLK-1001Splunk Core Certified User (SPLK-1001) Splunk Foundational 300 60 $9.99