The Databricks Data Engineer exams (Associate / Professional) test a broad set of skills: Delta Lake, Spark SQL, ETL pipelines, and data governance. This article shows the weight of each exam domain, then walks through representative practice questions for the most common patterns, explaining the level of knowledge expected and where to focus when answering.
DEA is a 45-question, 90-minute exam. The current version, revised on May 4, 2026, covers the 7 sections below. Both the section names and the weights changed from the old 5-domain outline, and governance (Governance and Security) rose from 11% in the previous version to 15%.
| Section | Weight | Key Topics |
|---|---|---|
| Databricks Intelligence Platform | 6% | Core platform components (architecture, Delta Lake, Unity Catalog); compute options with their characteristics, limitations, and cost models |
| Data Ingestion and Loading | 21% | Auto Loader, COPY INTO, Lakeflow Connect (standard/managed connectors), JDBC/ODBC, choosing an ingestion method, semi-structured data |
| Data Transformation and Modeling | 22% | Bronze-to-silver cleaning, joins (including broadcast joins), deduplication and aggregation, basic tuning parameters, Gold-layer objects, data quality checks |
| Working with Lakeflow Jobs | 16% | Tasks and dependencies (DAG), retries and conditional tasks, schedules and triggers (file arrival, table update) |
| Implementing CI/CD | 10% | Git Folders, Declarative Automation Bundles (formerly Databricks Asset Bundles), Databricks CLI |
| Troubleshooting, Monitoring, and Optimization | 10% | Job run history and monitoring, finding bottlenecks in the Spark UI (skew, shuffle, spill), Liquid Clustering and predictive optimization, diagnosing cluster startup failures and OOM errors |
| Governance and Security | 15% | Managed vs. external tables, GRANT / REVOKE / DENY, column masking and row-level security, ABAC policies |
DEP is the senior-level 60-question, 120-minute exam, dominated by long scenario questions. It tests practical skill in design judgment, troubleshooting, and performance optimization. It switched to a new exam on October 9, 2026, which covers the 9 sections below (the new exam is offered in English only).
| Section | Weight | Key Topics |
|---|---|---|
| Developing Code for Data Processing using Python and SQL | 23% | Project structure for bundles, library dependency troubleshooting, UDFs, Lakeflow Declarative Pipelines and Auto Loader, AUTO CDC APIs (SCD Type 1/2), Structured Streaming state, testing |
| Data Ingestion & Acquisition | 12% | Ingesting many formats and sources (Kafka, etc.), CDC ingestion with Lakeflow Connect, OpenSharing (D2D / Databricks-to-Open), Clean Rooms, Lakehouse Federation |
| Data Manipulation | 12% | Window functions, joins, aggregations, VARIANT type, ai_query, quarantining bad records with expectations |
| Monitoring and Alerting | 10% | System tables, REST API / CLI / SDK, pipeline event logs, alerts, Jobs UI |
| Cost & Performance Optimization | 15% | Managed tables, predictive optimization, Liquid Clustering, deletion vectors, Change Data Feed, query profile |
| Ensuring Data Security and Compliance | 8% | Least-privilege ACLs, ABAC row filters and column masks, anonymization and pseudonymization, PII masking, data purging |
| Data Governance | 5% | Metadata via tags and comments, the Unity Catalog permission inheritance model |
| Debugging and Deploying | 10% | Diagnosis with the Spark UI, cluster logs, and system tables; job repair runs; Declarative Automation Bundles (formerly Databricks Asset Bundles); Git folders |
| Data Modeling | 5% | Delta/Iceberg table layout design, dimensional models, materialized views, metric views |
NicheeLab's DEP question bank was rebuilt in November 2026 for the 9 sections above.
Data Engineer exam questions are not evenly distributed across domains — on DEA, the top 2 sections (Data Transformation and Modeling and Data Ingestion and Loading) alone account for 43% of the score. Studying by domain produces 3 concrete benefits.
MERGE INTO can contain multiple WHEN MATCHED / WHEN NOT MATCHED clauses, evaluated top to bottom. It is a core Delta Lake statement, and questions check whether you can accurately trace combinations of conditional DELETE, UPDATE SET *, and INSERT *. SCD Type 1 (overwrite with latest) and Type 2 (history preserved) are listed in the DEP exam outline (in the new exam, via the AUTO CDC APIs' stored_as_scd_type).
Auto Loader using the cloudFiles format behaves differently when new columns arrive depending on schemaEvolutionMode (addNewColumns / failOnNewColumns / rescue / none). The exam frequently asks what happens when JSON with a new column arrives. Remember that in rescue mode, unknown columns are stored in _rescued_data.
Unity Catalog privileges are managed in 3 levels: CATALOG → SCHEMA → TABLE/VIEW. GRANT USAGE only grants the right to access that level. The exam often tests that USAGE on a CATALOG alone is not enough to SELECT from underlying tables, and that GRANT SELECT ON SCHEMA ... TO ... grants SELECT on every table beneath the schema.
Lakeflow Spark Declarative Pipelines data quality constraints (Expectations) have 3 ON VIOLATION actions — WARN, DROP ROW, and FAIL — which respectively output the row with a warning only, drop the row and record it in metrics, or stop the pipeline. The exam can go as deep as asking where dropped row counts are recorded in the event log (flow_progress.data_quality.dropped_records).
Multi-task Workflows are tested on task dependencies (depends_on), retry policies (max_retries / retry_on_timeout), and notification settings. Common DEP patterns include the behavior where task B is skipped when its dependency task A fails, and how to configure conditional branch (if/else) tasks.
Below is one representative question each on Delta Lake (MERGE), data ingestion (Auto Loader), and governance (Unity Catalog). Try answering on your own before reading the explanation.
Delta Lake
Question 1
What is the correct behavior when the following MERGE statement runs? MERGE INTO silver USING bronze ON silver.id = bronze.id WHEN MATCHED AND bronze.op = 'DELETE' THEN DELETE WHEN MATCHED THEN UPDATE SET * WHEN NOT MATCHED AND bronze.op != 'DELETE' THEN INSERT *
Correct answer: B
Delta Lake MERGE evaluates WHEN MATCHED / WHEN NOT MATCHED clauses top to bottom. The first WHEN MATCHED conditionally deletes matched rows where bronze.op='DELETE'; the second WHEN MATCHED updates the remaining matched rows; the WHEN NOT MATCHED clause carries AND bronze.op != 'DELETE', so it inserts only unmatched rows whose op is not 'DELETE'. AND conditions are allowed on WHEN NOT MATCHED, so no syntax error occurs (C is wrong). This pattern is the canonical implementation for reflecting CDC (Change Data Capture) events into the silver layer.
Data Ingestion and Loading
Question 2
When schemaEvolutionMode='rescue' is set on Auto Loader (cloudFiles) and a JSON file arrives with a column not in the existing schema, what is the correct behavior?
Correct answer: A
Under schemaEvolutionMode='rescue', the schema is not auto-extended; values for columns or data types that do not match the existing schema are stashed in the _rescued_data column as a JSON string. The advantage is keeping schema stability without losing data. Behavior B corresponds to addNewColumns mode; behavior C corresponds to failOnNewColumns mode. Rescue mode is suited for safely handling unexpected schema changes in production pipelines, and questions distinguishing Auto Loader modes appear frequently on DEA.
Governance and Security
Question 3
After executing the following GRANT statements in Unity Catalog, what can analyst_group do? GRANT USAGE ON CATALOG prod_catalog TO analyst_group; GRANT USAGE ON SCHEMA prod_catalog.sales TO analyst_group; GRANT SELECT ON SCHEMA prod_catalog.sales TO analyst_group;
Correct answer: B
Unity Catalog privileges are hierarchical: you cannot access a lower level without USAGE at the higher level. This example grants 3 privileges: CATALOG-level USAGE (access to prod_catalog), SCHEMA-level USAGE (access to the sales schema), and SCHEMA-level SELECT (SELECT on every table under the sales schema). GRANT SELECT ON SCHEMA grants SELECT in bulk to all current and future tables under the schema. However, other schemas under prod_catalog (e.g., prod_catalog.marketing) have no USAGE grant, so they are inaccessible. There is no constraint on the order of GRANT statements, so D is incorrect.
Start by referencing the weight table and allocate 40%+ of study time to the high-weight sections (on DEA, Data Transformation and Modeling and Data Ingestion and Loading). These 2 sections make up 43% of the score, so answering them consistently brings the passing line within reach. Split the rest across Lakeflow Jobs, governance, CI/CD, troubleshooting, and the platform section.
Work through the question bank one domain at a time and record accuracy. Any domain below 70% is a weak area. For weak domains, re-read the relevant section of the official documentation, run code in Free Edition (the successor to Community Edition) to verify behavior, then redo the questions.
Both DEA and DEP feature questions where you read a code snippet and infer the behavior. The ability to instantly judge the outcome of MERGE statements, Auto Loader settings, Lakeflow Spark Declarative Pipelines Expectation definitions, etc., is the key to passing. Practice repeatedly in Free Edition by running the code and comparing the actual result against your prediction.
How do the exam domain weights differ between DEA (Data Engineer Associate) and DEP (Data Engineer Professional)?
DEA (May 4, 2026 version) has 7 sections, and Data Transformation and Modeling (22%) plus Data Ingestion and Loading (21%) account for 43% of the exam. DEP switched to a new exam on October 9, 2026 with 9 sections: Developing Code for Data Processing using Python and SQL (23%) is the largest, followed by Cost & Performance Optimization (15%). DEP centers on long scenario questions that require cross-domain design judgment.
If studying by domain, which domain should you tackle first?
The most efficient starting point is data transformation and processing (Spark SQL, PySpark), which has the highest weight and serves as the foundation for other domains: Data Transformation and Modeling (22%) on DEA and Developing Code for Data Processing using Python and SQL (23%) on DEP. After mastering Spark read/write operations, move to data ingestion (Auto Loader, COPY INTO, Lakeflow Connect), then Lakeflow Jobs (task dependencies, triggers), then governance (Unity Catalog GRANT, row filters, column masks). This order builds knowledge cumulatively and surfaces cross-domain relationships.
Should you do domain-by-domain practice and mock exams in parallel?
The most effective approach is to first solidify each domain through targeted practice, identify and shore up weak areas, then move to mock exams. Once you exceed 80% accuracy on domain practice, shift to full mock exams under the real time limit (90 minutes for DEA, 120 minutes for DEP). If a mock reveals new weaknesses, return to domain practice — this loop is the fastest path to passing.
Test your skills with the Data Engineer question bank
Sharpen your pass-ready skills with 850 DEA and 1,000 DEP questions (practice sets and mock exams)
Try free questions →Related Databricks Data Engineer Articles
Data Engineer Associate: Complete Guide
Deep dive on DEA scope, difficulty, and prep
Data Engineer Professional: Complete Guide
Deep dive on DEP scope, difficulty, and prep
Databricks Exam 2026 Update Notes
Summary of the latest DEA / DEP revisions
Free Databricks Question Bank
6,200+ bilingual practice questions
Practice with certification-focused question sets
Try free questionsNicheeLab Editorial Team
NicheeLab editorial team focused on data engineering and cloud certification learning. Content is structured around practical study needs and official exam domains.
Databricks Certifications: All 8 Exams, Difficulty & Study Plan (2026)
Complete guide to all 8 Databricks certifications — Data Eng...
Databricks Exam Difficulty Ranking: 7 Certs Compared (2026)
Seven Databricks certifications ranked by difficulty, with s...
Databricks Study Guide: Fastest Pass Route & Time Estimates (2026)
How to pass Databricks certifications efficiently. Official ...
Databricks Data Engineer Associate: Complete Guide (2026)
Domain-by-domain breakdown of the Databricks Certified Data ...
Databricks Data Engineer Professional: Complete Guide (2026)
Tactics for the Databricks Certified Data Engineer Professio...