Databricks Certified Data Engineer Professional (Data Engineer Professional) practice exam and study path
A free, timed 60-question Data Engineer Professional practice exam in 120 minutes, scored by domain, with every option explained after you submit. Also 240 practice questions you can check one at a time, a page for every task in the exam guide, and a study path. No sign-up.
$11.99for 12 months
The advanced Databricks data engineering exam: production pipelines in Python and SQL with Lakeflow pipelines, Structured Streaming and Lakeflow Jobs, CDC and sharing, monitoring with system tables and alerts, Delta Lake cost and performance tuning, security and compliance in Unity Catalog, debugging and deploying with bundles and Git folders, and data modeling.
The exam
- Exam code
- Data Engineer Professional
- Questions
- Not yet published
- Time
- 120 minutes
- Passing score
- Not published
- Exam fee
- $200 (USD)
- Question types
- multiple choice, multiple response
60 scored multiple-choice questions in 120 minutes (unscored questions may be included and are not identified; extra time is already counted in the limit), USD 200 plus applicable taxes, online proctored or at a test center, no test aides, in English. No prerequisite; related training is highly recommended, with one year of hands-on experience in the tasks of the outline. Valid for 2 years; to recertify you take the current live exam. Passing score: Not published. This outline is the version published on October 9, 2026.
From Databricks's certification page and exam guide, checked Nov 1, 2026.
Domains and weights
Domain 1: Developing Code for Data Processing using Python and SQL
23%
Domain 2: Data Ingestion & Acquisition
12%
Domain 3: Data Manipulation
12%
Domain 4: Monitoring and Alerting
10%
Domain 5: Cost & Performance Optimization
15%
Domain 6: Ensuring Data Security and Compliance
8%
Domain 7: Data Governance
5%
Domain 8: Debugging and Deploying
10%
Domain 9: Data Modeling
5%
On our roadmap this comes after Data Engineer Associate. See every certification.
Practice
240 original practice questions, every option explained with the Databricks documentation page that proves it. Free, no sign-up; progress stays on this device.
240 questions · practice mode
All domains
Every sample question for this exam, in domain order.
62 questions · practice mode
Topic quiz — Domain 1: Developing Code for Data Processing using Python and SQL
A topic quiz on domain 1 (23% of the exam).
27 questions · practice mode
Topic quiz — Domain 2: Data Ingestion & Acquisition
A topic quiz on domain 2 (12% of the exam).
23 questions · practice mode
Topic quiz — Domain 3: Data Manipulation
A topic quiz on domain 3 (12% of the exam).
26 questions · practice mode
Topic quiz — Domain 4: Monitoring and Alerting
A topic quiz on domain 4 (10% of the exam).
33 questions · practice mode
Topic quiz — Domain 5: Cost & Performance Optimization
A topic quiz on domain 5 (15% of the exam).
25 questions · practice mode
Topic quiz — Domain 6: Ensuring Data Security and Compliance
A topic quiz on domain 6 (8% of the exam).
11 questions · practice mode
Topic quiz — Domain 7: Data Governance
A topic quiz on domain 7 (5% of the exam).
22 questions · practice mode
Topic quiz — Domain 8: Debugging and Deploying
A topic quiz on domain 8 (10% of the exam).
11 questions · practice mode
Topic quiz — Domain 9: Data Modeling
A topic quiz on domain 9 (5% of the exam).
60 questions · 120 min · timed
Full practice exam
The real exam's pace, no feedback until you submit.
60 questions · 120 min · timed · exam pack
Practice exam 1
Included in the Data Engineer Professional exam pack.
60 questions · 120 min · timed · exam pack
Practice exam 2
Included in the Data Engineer Professional exam pack.
60 questions · 120 min · timed · exam pack
Practice exam 3
Included in the Data Engineer Professional exam pack.
More practice exams
The lessons, the sample questions on every task page and the first full practice exam are free and stay free. A pack adds the further timed Data Engineer Professional practice exams.
Data Engineer Professional exam pack
$11.99for 12 months
- Every paid Data Engineer Professional practice exam, timed, with every option explained
- The next version of this exam included when it changes within your 12 months
- 12 months of access. One payment, nothing renews by itself.
- 14-day refund, no conditions
- 14-day refund, no conditions: ask within 14 days of buying and you get the whole payment back.
- No pass guarantee. These are practice exams written by us from the exam guide and the Databricks documentation; a score here does not predict your result on the real exam.
Study path
One module per exam domain. Lessons that already exist on BytePatterns are linked; the rest are being written.
Module 1: Developing Code for Data Processing using Python and SQL
1Bundle project layout: includes, a src package, wheel artifacts and Python resourcesTask 1.1
Lesson coming
2Library failures: serverless environments, pipeline dependencies, wheels and requirements filesTask 1.2
Partly covered by: Images, Layers & Multi-Stage Builds
3SQL, Python, batch and pandas UDFs, and Unity Catalog functionsTask 1.3
Lesson coming
4Streaming pipelines with Auto Loader: file events, schema evolution and modesTask 1.4
Partly covered by: SQS vs SNS vs EventBridge
5Jobs from the UI, the Jobs API, the CLI and the SDKTask 1.5
Lesson coming
6Streaming table or materialized view: latency, cost and refreshTask 1.6
Lesson coming
7AUTO CDC: keys, sequencing, deletes, SCD type 1 and type 2Task 1.7
Lesson coming
8Declarative pipelines or hand-written Structured StreamingTask 1.8
Partly covered by: Message Queues
9If/else conditions, For each loops and Run ifTask 1.9
Lesson coming
10Serverless environments, performance mode, memory and retriesTask 1.10
Partly covered by: Requests, Limits & HPA, Pods, ReplicaSets & Deployments
11Testing transformations: transform, assertDataFrameEqual, assertSchemaEqual and pytestTask 1.11
Lesson coming
12Stateful streaming: watermarks, output modes, foreachBatch and checkpointsTask 1.12
Partly covered by: Design Ad Click Aggregation
Module 2: Data Ingestion & Acquisition
13Kafka, Kinesis, Pub/Sub, files and table formats as sourcesTask 2.1
Partly covered by: SQS vs SNS vs EventBridge, Moving Data Into AWS
14Incremental CDC pipelines into Delta and Iceberg-readable targetsTask 2.2
Partly covered by: Database Replication
15Lakeflow Connect database connectors: gateway, pipeline and history trackingTask 2.3
Lesson coming
16OpenSharing and Clean RoomsTask 2.4
Lesson coming
17Lakehouse Federation: connections, foreign catalogs and permissionsTask 2.5
Lesson coming
Module 3: Data Manipulation
18Window functions, joins and aggregations at scaleTask 3.1
Partly covered by: Window Functions, Query Execution Order
19VARIANT: parse_json, paths, variant_get and shreddingTask 3.2
Lesson coming
20AI functions and ai_query in pipelinesTask 3.3
Partly covered by: Training vs Inference, What Is an LLM
21Expectations: warn, drop, fail and quarantineTask 3.4
Partly covered by: Data Readiness for AI
Module 4: Monitoring and Alerting
22System tables for cost, audit and workload monitoringTask 4.1
Partly covered by: AWS Cost Levers
23Monitoring jobs and pipelines with the REST API, CLI and SDKTask 4.2
Lesson coming
24The pipeline event logTask 4.3
Lesson coming
25Databricks SQL alerts and alert tasksTask 4.4
Partly covered by: CloudWatch, Alarms & X-Ray
26Job run states, thresholds and notificationsTask 4.5
Partly covered by: Observability Basics
Module 5: Cost & Performance Optimization
27Managed tables, predictive optimization and automatic liquid clusteringTask 5.1
Lesson coming
28Deletion vectors, liquid clustering and CLUSTER BY AUTOTask 5.2
Lesson coming
29The disk cache and query result cachingTask 5.3
Partly covered by: Caching, Invalidation and Eviction
30Change data feed for incremental downstream processingTask 5.4
Lesson coming
31Reading the query profileTask 5.5
Partly covered by: Reading a Query Plan
32Liquid clustering, partitioning and Z-orderTask 5.6
Partly covered by: Indexes, Database Sharding
Module 6: Ensuring Data Security and Compliance
33Least privilege on Unity Catalog objects and workspace resourcesTask 6.1
Partly covered by: Shared Responsibility & IAM
34ABAC policies with governed tagsTask 6.2
Lesson coming
35Hashing, tokenization, suppression and generalizationTask 6.3
Partly covered by: Finding and Masking PII, KMS, Envelope Encryption & Private CA
36PII detection and masking across batch and streamingTask 6.4
Partly covered by: Finding and Masking PII
37Purging data for retention and erasure requestsTask 6.5
Partly covered by: S3: Consistency, Classes, Lifecycle
Module 7: Data Governance
38Tags and comments for discoveryTask 7.1
Lesson coming
39How privileges inherit through catalogs, schemas and objectsTask 7.2
Partly covered by: Organizations, SCPs & Control Tower
Module 8: Debugging and Deploying
40Diagnostics: Spark UI, compute logs, system tables and query profilesTask 8.1
Partly covered by: Tracing a Request
41Repairing failed runs and overriding parametersTask 8.2
Lesson coming
42Deploying bundles: targets, modes, identities and permissionsTask 8.3
Partly covered by: ConfigMaps, Secrets & Env
43Git folders in CI/CDTask 8.4
Lesson coming
Module 9: Data Modeling
44Table layouts: partition grain, clustering keys and file sizesTask 9.1
Partly covered by: Database Sharding
45Dimensional models, materialized views and metric viewsTask 9.2
Partly covered by: Aggregations & GROUP BY
Every task in the exam guide
The exam guide splits each domain into task statements. Each one has a page with a short summary, the lessons that teach it and open sample questions.
Domain 1: Developing Code for Data Processing using Python and SQL
- 1.1Implement scalable Python project structures for Declarative Automation Bundles (formerly Databricks Asset Bundles / DABs) to support modular development and CI/CD integration.5 sample questions
- 1.2Apply troubleshooting techniques to dependency conflicts and installation failures for external libraries (PyPI, local wheels, source archives) across serverless, pipeline, and bundle-deployed environments.5 sample questions
- 1.3Develop User-Defined Functions (UDFs) using Pandas, Python, and SQL, including Unity Catalog functions for the given constraints.5 sample questions
- 1.4Create production-ready data pipelines for streaming data using Lakeflow Pipelines and Auto Loader.6 sample questions
- 1.5Create and automate ETL workloads using Lakeflow Jobs via the UI, API, and CLI.5 sample questions
- 1.6Choose between a streaming table and a materialized view for a given latency, cost, and refresh requirement.5 sample questions
- 1.7Implement CDC pipelines using AUTO CDC APIs (formerly APPLY CHANGES) in Lakeflow Pipelines, including SCD Type 1 and Type 2 via stored_as_scd_type.5 sample questions
- 1.8Choose between Spark Structured Streaming and Apache Spark™ Declarative Pipelines for scalable ETL given operational constraints.5 sample questions
- 1.9Create Lakeflow Jobs that use control-flow operators such as If/Else conditions and For Each loops.5 sample questions
- 1.10Choose appropriate compute and configuration for environments and dependencies — including serverless compute (serverless environments, dependency management, performance mode), high-memory notebook tasks, and auto-optimization settings (e.g., disallowing retries).5 sample questions
- 1.11Develop unit and integration tests using assertDataFrameEqual, assertSchemaEqual, DataFrame.transform, and testing frameworks to ensure code correctness.5 sample questions
- 1.12Apply Structured Streaming stateful-processing semantics, including watermarks, output modes, foreachBatch, and checkpoints for fault-tolerant exactly-once state recovery.6 sample questions
Domain 2: Data Ingestion & Acquisition
- 2.1Develop data ingestion pipelines to ingest a variety of data formats, including Delta Lake, Parquet, JSON, Iceberg, CSV, and Binary from diverse sources such as message buses (Kafka, Kinesis, Pub/Sub) and cloud storage.6 sample questions
- 2.2Configure incremental CDC pipelines using Lakeflow Pipelines with Delta or Iceberg as the target table format.6 sample questions
- 2.3Configure CDC ingestion pipelines from relational database sources, including SQL Server, MySQL, and PostgreSQL, using Lakeflow Connect.5 sample questions
- 2.4Implement OpenSharing (D2D and Databricks-to-Open) and Clean Rooms for privacy-preserving collaboration.5 sample questions
- 2.5Configure Lakehouse Federation with governance across supported source systems, applying UC permissions and connection-level credentials.5 sample questions
Domain 3: Data Manipulation
- 3.1Apply advanced data transformations, including window functions, joins, and aggregations, using Spark SQL and PySpark to process large datasets.6 sample questions
- 3.2Develop a model and query semi-structured data using the VARIANT data type and related functions (e.g., parse_json, variant_get).6 sample questions
- 3.3Apply AI functions, including ai_query, to perform model inference within data pipelines for enrichment and classification tasks.5 sample questions
- 3.4Implement data quality expectations in Lakeflow Pipelines to quarantine, drop, or fail on bad records.6 sample questions
Domain 4: Monitoring and Alerting
- 4.1Use Databricks system tables (billing, compute, access, lakeflow) for cost analysis, auditing, and workload monitoring.6 sample questions
- 4.2Use Databricks REST APIs / CLI and SDK for monitoring and analyzing jobs and pipelines.5 sample questions
- 4.3Use Pipeline event logs to monitor pipeline health and data quality.5 sample questions
- 4.4Use Databricks Lakehouse alerts to monitor governed business metrics, data quality and anomaly signals, usage and cost, SQL warehouse/query health, audit and security events, AI agent quality, and Lakeflow Job branching.5 sample questions
- 4.5Use Lakeflow Jobs UI and Jobs API to monitor job status and performance metrics.5 sample questions
Domain 5: Cost & Performance Optimization
- 5.1Explain how Unity Catalog managed tables, Predictive Optimization, and Liquid Clustering reduce operational and maintenance overhead for a given workload.5 sample questions
- 5.2Choose the appropriate Delta optimization technique (deletion vectors, Liquid Clustering, CLUSTER BY AUTO) for a given table access pattern.6 sample questions
- 5.3Understand how caching (Delta cache) improves query performance for repeated reads of the same data.5 sample questions
- 5.4Apply Change Data Feed (CDF) to expose row-level changes (updates/deletes) for efficient incremental downstream processing.5 sample questions
- 5.5Use the query profile to identify performance bottlenecks, such as data-skipping inefficiencies, join strategies, and shuffle operations.6 sample questions
- 5.6Compare Liquid Clustering vs partitioning/ZORDER for a given table size and query pattern.6 sample questions
Domain 6: Ensuring Data Security and Compliance
- 6.1Apply least-privilege access control lists (ACLs) to secure Unity Catalog securable objects and workspace resources.5 sample questions
- 6.2Apply attribute-based access control (ABAC) policies with governed tags to enforce row filters and column masks at scale.5 sample questions
- 6.3Apply anonymization and pseudonymization methods — such as hashing, tokenization, suppression, and generalization — to confidential data (e.g., using column masks and related Unity Catalog features).5 sample questions
- 6.4Implement a compliant data pipeline that enforces PII detection and masking controls across batch and streaming workloads using Unity Catalog features.5 sample questions
- 6.5Implement a data purging strategy that satisfies data retention and deletion policies (e.g., GDPR right-to-erasure, GDPR right-to-be-forgotten deletion) using Delta Lake and Unity Catalog features.5 sample questions
Domain 7: Data Governance
- 7.1Demonstrate understanding of Unity Catalog tags and comments as mechanisms for adding metadata to securable objects to improve data discoverability.5 sample questions
- 7.2Demonstrate understanding of the Unity Catalog permission inheritance model as a mechanism for managing access control across catalogs, schemas, and objects.6 sample questions
Domain 8: Debugging and Deploying
- 8.1Identify pertinent diagnostic information using Spark UI, cluster logs, system tables, and query profiles to troubleshoot errors.5 sample questions
- 8.2Analyze the errors and remediate the failed job runs with job repairs and parameter overrides.6 sample questions
- 8.3Deploy Databricks resources using Declarative Automation Bundles (formerly Databricks Asset Bundles).6 sample questions
- 8.4Configure Git-based CI/CD workflows using Databricks Git folders (formerly Repos) to deploy notebooks and code.5 sample questions
Domain 9: Data Modeling
- 9.1Design scalable Delta/Iceberg table layouts for large data assets by mapping partitioning to data grain, aligning clustering to relationship access patterns, and maintaining balanced file sizes through compaction.6 sample questions
- 9.2Design dimensional models for analytical workloads, leveraging Materialized Views for pre-computed aggregation and Unity Catalog Metric Views for governed, reusable metric definitions, to ensure efficient querying and aggregation.5 sample questions
How these questions are made
- Written by us from the exam guide's task statements and the Databricks documentation — never from real exam content.
- Every option carries its own explanation and a link to the Databricks page that proves it.
- A question enters a timed exam only after an independent check; until then it is a practice question.
- Results are a plain percentage, per domain too — not an imitation of Databricks's scaled score.
Questions about the Data Engineer Professional practice exam
- Is the Data Engineer Professional practice exam free?
- Yes. The full practice exam (60 questions, 120 minutes) is free with no sign-up, and so are the 240 practice questions, the task pages and the study path. Your attempts are saved in this browser, on this device.
- How many questions does it have, and is it timed?
- 60 questions in 120 minutes: the real Data Engineer Professional pace, scaled to this form. When the time runs out, the exam is submitted as it stands.
- Are the answers explained?
- After you submit, not during: like the real exam, the timed exam gives no feedback until the end. Then you get your score overall and per exam domain, and every question with each option explained and a link to the Databricks documentation page behind it. In practice mode an answer is explained as soon as you check it.
- What does the Data Engineer Professional exam pack add?
- 3 more timed practice exams (Practice exam 1: 60 questions, 120 minutes; Practice exam 2: 60 questions, 120 minutes; Practice exam 3: 60 questions, 120 minutes), each scored and explained the same way, and the next version of this exam if it changes within your 12 months. 12 months of access. One payment, nothing renews by itself. Everything above stays free. See the pack.
- Can I get a refund?
- Yes, with no conditions: ask within 14 days of buying and you get the whole payment back. The details are in the terms.
- Is this an official Databricks practice exam?
- No. BytePatterns is not affiliated with, endorsed or sponsored by Databricks. Every question is written by us from the public exam guide and the Databricks documentation, never from real exam content, and a score here does not predict your result on the real exam. Databricks lists its own preparation resources on its certification page.