cert-bank

Exams

DBX-DEP Databricks Data Engineer Professional

Vendor
Databricks
Level
Professional
Questions
60
Time
120 min
Domains
9
In the bank
360

Practice 360 questionsTake a timed mock examDay-by-day study plan

Guides for this exam

The exam at a glance

LevelProfessional
Questions60
Time120 minutes (about 2 minutes per question)
Passing markNot published by the vendor

Domains and weights

DomainWeightPractice questions here
D1 · Developing Code for Data Processing using Python and SQL23%83
D2 · Data Ingestion & Acquisition12%43
D3 · Data Manipulation12%43
D4 · Monitoring and Alerting10%36
D5 · Cost & Performance Optimization15%54
D6 · Ensuring Data Security and Compliance8%29
D7 · Data Governance5%18
D8 · Debugging and Deploying10%36
D9 · Data Modeling5%18

D1 · Developing Code for Data Processing using Python and SQL 23%

Code questions show a pipeline, job or bundle that misbehaves or must change, often with a snippet of YAML, Python or SQL, and ask for the fix. How Declarative Pipelines, Lakeflow Jobs and bundles resolve paths, dependencies and targets usually decides. Strong options change the one setting that explains the symptom; weaker ones rewrite the pipeline or switch compute without cause.

What to watch for

Tasks in the official exam guide (12)
  • 1.1 Implement scalable Python project structures for Declarative Automation Bundles
  • 1.2 Troubleshoot dependency conflicts and installation failures for external libraries
  • 1.3 Develop UDFs with Pandas, Python and SQL, including Unity Catalog functions
  • 1.4 Create production-ready streaming pipelines with Lakeflow Pipelines and Auto Loader
  • 1.5 Create and automate ETL workloads with Lakeflow Jobs via UI, API and CLI
  • 1.6 Choose between a streaming table and a materialized view
  • 1.7 Implement CDC pipelines with AUTO CDC APIs (SCD Type 1 and 2)
  • 1.8 Choose between Structured Streaming and Spark Declarative Pipelines
  • 1.9 Create Lakeflow Jobs with control-flow operators (If/Else, For Each)
  • 1.10 Choose compute and configuration for environments and dependencies
  • 1.11 Develop unit and integration tests for pipeline code
  • 1.12 Apply Structured Streaming stateful-processing semantics

D2 · Data Ingestion & Acquisition 12%

Ingestion questions describe a source such as Kafka, a database or files, and a change: a new topic, missed data, a schema change. How streaming checkpoints and offsets behave usually decides. Strong options work with the checkpoint (or start a new one on purpose); weaker ones change options that a running checkpoint ignores.

What to watch for

Tasks in the official exam guide (5)
  • 2.1 Ingest diverse formats from message buses and cloud storage
  • 2.2 Configure incremental CDC pipelines with Delta or Iceberg targets
  • 2.3 Configure CDC ingestion from relational databases with Lakeflow Connect
  • 2.4 Implement OpenSharing and Clean Rooms for privacy-preserving collaboration
  • 2.5 Configure Lakehouse Federation with governance

D3 · Data Manipulation 12%

Manipulation questions give a table shape and a target result and ask for the SQL or pipeline step that produces it. Nulls, ordering and semi-structured data usually decide. Strong options use the function that fits the shape, such as a window function or VARIANT access; weaker ones add joins or collect data to the driver.

What to watch for

Tasks in the official exam guide (4)
  • 3.1 Apply advanced transformations with Spark SQL and PySpark
  • 3.2 Model and query semi-structured data with VARIANT
  • 3.3 Apply AI functions such as ai_query in data pipelines
  • 3.4 Implement data quality expectations in Lakeflow Pipelines

D4 · Monitoring and Alerting 10%

Monitoring questions describe a failed run, a cost question or an audit need and ask where to look or what to set up. Which record keeps the information, and for how long, usually decides. Strong options read the right system table, event log or API; weaker ones rely on UI views that keep data only for a limited time.

What to watch for

Tasks in the official exam guide (5)
  • 4.1 Use system tables for cost analysis, auditing and workload monitoring
  • 4.2 Use REST APIs, CLI and SDK to monitor jobs and pipelines
  • 4.3 Use pipeline event logs to monitor health and data quality
  • 4.4 Use Lakehouse alerts to monitor business and operational signals
  • 4.5 Use the Lakeflow Jobs UI and Jobs API to monitor runs

D5 · Cost & Performance Optimization 15%

Optimization questions describe slow queries or rising cost on Delta tables and ask which layout or setting helps. How the table is queried and maintained usually decides. Strong options let liquid clustering, predictive optimization or caching do the work they are built for; weaker ones keep manual OPTIMIZE and ZORDER jobs that fight them.

What to watch for

Tasks in the official exam guide (6)
  • 5.1 Explain how managed tables, Predictive Optimization and Liquid Clustering reduce overhead
  • 5.2 Choose the Delta optimization technique for a table access pattern
  • 5.3 Understand how caching improves repeated reads
  • 5.4 Apply Change Data Feed for incremental downstream processing
  • 5.5 Use the query profile to identify performance bottlenecks
  • 5.6 Compare Liquid Clustering with partitioning and ZORDER

D6 · Ensuring Data Security and Compliance 8%

Security questions describe a group that needs to do one thing with a job, pipeline or table and must not do more. Which permission level grants exactly that usually decides. Strong options pick the narrowest ACL or Unity Catalog privilege, or a row filter or column mask; weaker ones hand out ownership or admin rights.

What to watch for

Tasks in the official exam guide (5)
  • 6.1 Apply least-privilege ACLs to Unity Catalog and workspace objects
  • 6.2 Apply ABAC policies with governed tags for row filters and column masks
  • 6.3 Apply anonymization and pseudonymization methods
  • 6.4 Implement a compliant pipeline with PII detection and masking
  • 6.5 Implement a data purging strategy for retention and deletion policies

D7 · Data Governance 5%

Governance questions describe stewards, catalogs and schemas and ask what a grant or privilege really allows. How Unity Catalog privileges inherit and who may grant them usually decides. Strong options grant at the level that covers future objects too; weaker ones grant object by object or assume MANAGE includes reading data.

What to watch for

Tasks in the official exam guide (2)
  • 7.1 Use Unity Catalog tags and comments for discoverability
  • 7.2 Understand the Unity Catalog permission inheritance model

D8 · Debugging and Deploying 10%

Deployment questions describe Git folders, bundles and CI workflows, and ask how to ship changes safely or debug a run. Which tool owns the deployment usually decides. Strong options deploy with bundles to a target under a service principal and use the Spark UI or system tables to debug; weaker ones edit production by hand.

What to watch for

Tasks in the official exam guide (4)
  • 8.1 Identify diagnostic information with Spark UI, logs, system tables and query profiles
  • 8.2 Remediate failed runs with job repairs and parameter overrides
  • 8.3 Deploy resources with Declarative Automation Bundles
  • 8.4 Configure Git-based CI/CD with Databricks Git folders

D9 · Data Modeling 5%

Modeling questions describe how tables grow and are read, and ask for the table design or maintenance that keeps them healthy. Small files, history and query patterns usually decide. Strong options match managed tables, clustering, materialized views or metric views to the use; weaker ones copy data into extra tables to work around a design.

What to watch for

Tasks in the official exam guide (2)
  • 9.1 Design scalable Delta and Iceberg table layouts
  • 9.2 Design dimensional models with materialized views and Metric Views

A study order that works

The 25-day study plan for DBX-DEP takes the domains in this order. Each day has a short reading, key terms and a quiz from the bank.

  1. Days 1–6: D1 · Developing Code for Data Processing using Python and SQL
  2. Days 7–9: D2 · Data Ingestion & Acquisition
  3. Days 10–12: D3 · Data Manipulation
  4. Days 13–15: D4 · Monitoring and Alerting
  5. Days 16–18: D5 · Cost & Performance Optimization
  6. Days 19–20: D6 · Ensuring Data Security and Compliance
  7. Days 21–23: D8 · Debugging and Deploying
  8. Day 24: D9 · Data Modeling
  9. Day 25: Final Review: Decision Cheat-Sheet Across the Nine Domains

Recent changes to these questions

About these questions

Every question is original, written from the public exam guide and checked against the vendor's own documentation. None comes from a real exam. Each one has an explanation of why the answer is right and why the other options are wrong. How the questions are written.