Certification roadmap

Data Engineer Associate

The entry-level certification for data engineering on Databricks. Ingestion, transformation, Lakeflow Jobs, CI/CD with bundles, troubleshooting, and governance with Unity Catalog.

Names this guide still uses

All renames

The guide is version 2026-05. Databricks has renamed 6 things it covers since then. In the question, expect the name on the left. In the product, you will see the one on the right.

01

Databricks Intelligence Platform

6 concepts
6%
Exam guide objectives
  • Platform components: architecture, Delta Lake, Unity Catalog
  • Compute services: characteristics, limits, cost model, choosing the right one for a workload
02

Data Ingestion and Loading

8 concepts
21%
Exam guide objectives
  • Batch, streaming, and incremental ingestion patterns; sources: local files, standard connectors, and Lakeflow Connect managed connectors
  • COPY INTO to load files from object storage into Unity Catalog tables
  • Auto Loader with schema enforcement and evolution in batch mode (directory listing, file notification)
  • Lakeflow Connect for enterprise sources
  • JDBC/ODBC and REST clients from notebooks, orchestrated with Lakeflow Jobs
  • Choosing between Auto Loader, Lakeflow Connect, partner connectors, and other methods
  • Ingesting semi-structured and unstructured data (JSON, nested)
03

Data Transformation and Modeling

8 concepts
22%
Exam guide objectives
  • Cleaning data from bronze to silver with PySpark/SQL: nulls, types, writes
  • Joins (inner, left, broadcast, multiple keys, cross), union and union all
  • Manipulating columns, rows, and structure: add, drop, split, rename, filter, explode
  • Deduplication and aggregations: count, approx count distinct, mean, summary
  • Basic tuning parameters and performance measurement
  • Gold-layer objects: materialized views, views, streaming tables, tables
  • Quality checks and validation rules on silver and gold
04

Working with Lakeflow Jobs

8 concepts
16%
Exam guide objectives
  • Control flow: retries, conditional tasks, branching, loops
  • Common tasks (notebook, SQL, dashboard, pipeline) and dependencies in the DAG
  • Scheduling and trigger types: scheduled, file arrival, table update
  • Time-based or data-driven triggers depending on data availability and dependencies
05

Implementing CI/CD

4 concepts
10%
Exam guide objectives
  • Development workflow in the workspace: branch, commit, push, pull request with Git folders
  • Per-environment configuration with bundle variables and overrides
  • Deploying Declarative Automation Bundles for jobs, pipelines, and other assets across dev, test, and prod
  • Databricks CLI to validate, deploy, and manage bundles in CI/CD
06

Troubleshooting, Monitoring, and Optimization

10 concepts
10%
Exam guide objectives
  • Performance trends from job run history
  • Monitoring pipeline health from the UI: states, DAG graph, timings, failure rate
  • Bottlenecks (skew, shuffle, spill) from stage metrics in the Spark UI
  • Liquid Clustering and predictive optimization
  • Diagnosing failed cluster startup, library conflicts, out of memory
07

Governance and Security

7 concepts
15%
Exam guide objectives
  • Managed and external tables: differences and basic operations
  • GRANT, REVOKE, and DENY on principals at the right levels of the hierarchy
  • Column masking and row-level security
  • ABAC policies for centralized row filters and masks

How to use this roadmap

The domains follow the order of the official exam guide (May 4, 2026 version). The weight tells you how many questions to expect: 45 questions in 90 minutes, so roughly 10 questions on ingestion and 7 on jobs.

Study advice: start with the heaviest domains (ingestion, transformation) and finish with governance, which is more about memorization. Jobs and CI/CD are the domains where hands-on practice matters more than reading: build a real job, break it, repair it.

Full resources for this track

dbdemos: one-command Databricks demosRepository · Databricks · checked 10 Sept 2026FreeDatabricks on YouTubeVideo · Databricks · checked 10 Sept 2026FreeAdvancing Analytics on YouTubeVideo · Advancing Analytics · checked 10 Sept 2026FreeDatabricks Academy: training and certificationCourse · Databricks Academy · checked 10 Sept 2026FreeThe Big Book of Data Engineering (free ebook)Book · Databricks · checked 10 Sept 2026FreeLearning Spark, 2nd edition (free ebook)Book · O'Reilly / Databricks · checked 10 Sept 2026Free