DDEA

Databricks Data Engineer Associate (DDEA) practice exams

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

Read the DDEA study guide: what the exam covers, a 4-week plan and the topics people miss.

Exam at a glance

DDEA practice exam settings
Practice tests 5
Questions in total 215
Questions per test About 46
Time limit per test 90 minutes
Pass mark 70%
Question types Single answer and multiple answer (18 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

DDEA exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Databricks Intelligence Platform 6% 12
Data Ingestion and Loading 21% 45
Data Transformation and Modeling 22% 48
Working with Lakeflow Jobs 16% 34
Implementing CI/CD 10% 21
Troubleshooting, Monitoring, and Optimization 10% 22
Governance and Security 15% 33

Sample questions

Question 1 of 3

A data engineering team runs a nightly ETL notebook as a scheduled job. Today it runs on an all-purpose cluster that developers also use during the day. The team wants to lower the cost of the nightly run without changing the notebook code. What should they do?

  1. A Attach the job to a cluster pool so idle instances left over from the daytime cluster are reused at night
  2. B Keep the all-purpose cluster but enable autoscaling with a lower maximum worker count overnight
  3. C Move the notebook to a SQL warehouse so the run is billed at the warehouse DBU rate instead
  4. D Run the notebook as a job task on job compute or serverless jobs compute instead of the all-purpose cluster (correct answer)
Why: Job compute (classic job clusters or serverless jobs compute) is billed at a lower DBU rate than all-purpose compute and exists only for the run, so moving the scheduled task off the interactive cluster cuts cost without code changes. Autoscaling limits still bill all-purpose rates. A SQL warehouse cannot run an arbitrary Python notebook ETL, and pools reduce startup time rather than the DBU rate charged for all-purpose usage.

Question 2 of 3

A pipeline must ingest an operational SQL Server database incrementally into Unity Catalog using a Lakeflow Connect managed connector. Which component does this connector type use to extract snapshots and change data from the source database before the ingestion pipeline applies them?

  1. A A JDBC connection opened from a notebook task that polls the source tables for updated timestamps
  2. B A partner connector from Partner Connect that replicates the database into an external location
  3. C A Delta Sharing recipient configured on the SQL Server side to push every table change into Databricks tables
  4. D An ingestion gateway that runs on classic compute and stages extracted data in a Unity Catalog volume (correct answer)
Why: Lakeflow Connect database connectors such as SQL Server use an ingestion gateway that connects to the source, captures snapshots and change data, and stages it in Unity Catalog storage; a separate ingestion pipeline then applies the changes to target tables. Partner Connect tools are third-party alternatives, not this connector's components. A hand-built JDBC polling notebook is a custom approach, and Delta Sharing shares Delta data rather than extracting from SQL Server.

Question 3 of 3

Auditors ask the data team to record, for every bronze row, which source file it came from. The files are ingested with Auto Loader. What is the simplest way to capture this?

  1. A Call input_file_name() inside a Python UDF applied to each row after the write
  2. B Query the Delta transaction log afterwards to match each row to its add action
  3. C Enable change data feed on the bronze table to record the source of every insert
  4. D Select the _metadata.file_path field and store it in a column during ingestion (correct answer)
Why: File-based sources expose a hidden _metadata column whose file_path (and file name, size and modification time) can be selected during ingestion. input_file_name() is legacy and is not supported in Unity Catalog standard access mode, and using it after the write would no longer know the source. The transaction log records data files of the table, not source files, and change data feed tracks row changes, not source file paths.

What your score report looks like

Example attempt, DDEA practice test 3

75%

Passed
Pass mark 70%

Score by exam domain
DomainWeightYour score%
Databricks Intelligence Platform 6%
88
Data Ingestion and Loading 21%
81
Data Transformation and Modeling 22%
76
Working with Lakeflow Jobs 16%
58
Implementing CI/CD 10%
84
Troubleshooting, Monitoring, and Optimization 10%
72

Study next: Working with Lakeflow Jobs. It is below the pass mark and carries 16% of the exam.

Domains and pass mark from our DDEA 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 Data Transformation and Modeling and Data Ingestion and Loading, 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 DDEA practice exams

Are these real DDEA exam questions?
No. We write every question ourselves and map it to the published DDEA 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. DDEA 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