Original questions, written to the 2026 exam guide
Why these and not a dump
These are practice questions, not leaked exam content. Each one teaches the concept the real exam tests, with an explanation you can check against the Databricks docs. Why dumps fail →
Developing Code for Data Processing using Python and SQL
- A data engineering team is building a production Databricks Job that uses a custom internal Python library (`mycompany-utils==2.3.1`)…
- A data engineering team needs to apply a complex data masking transformation to a `pii_value` STRING column in a large PySpark DataFrame…
- A data engineering team is deploying a Databricks Job with a Lakeflow Spark Declarative Pipeline task. The pipeline runs in `TRIGGERED`…
- A senior data engineer is designing a new production Python project to be deployed via Databricks Asset Bundles across three environments…
- A data engineering team is operating a production Lakeflow Spark Declarative Pipeline in `TRIGGERED` mode that processes financial…
- A data engineering team has a Lakeflow Spark Declarative Pipeline that ingests from 5 different Auto Loader sources into 5 separate Bronze…
- A data engineer has built an internal Python library and packaged it as a wheel file (`mylib-1.0.0-py3-none-any.whl`). The library contains…
- A data engineering team is building a production pipeline that ingests raw JSON event files landing continuously in an Azure Data Lake…
- A data engineering team is building a CDC pipeline using Lakeflow Spark Declarative Pipelines. The source is a Kafka topic that emits…
- A data engineering team has a monorepo containing multiple Databricks Asset Bundle projects for different product domains. Each project has…
- A data engineering team has an existing production Spark Structured Streaming job written in PySpark that reads from Delta Lake, applies a…
- A data engineering team needs to programmatically trigger a Databricks Job from an external orchestration system (Apache Airflow running…
- A data engineering team maintains a Databricks Job that processes data for 12 different retail brands. Each brand has a separate source…
- A data engineer is writing unit tests for a PySpark transformation function `apply_revenue_adjustments(df: DataFrame) -> DataFrame` that…
Cost & Performance Optimisation
- A data engineering team enables change data feed on a Silver Delta table (`delta.enableChangeDataFeed = true`) to power a downstream audit…
- A solutions architect is evaluating whether to register new production Delta Lake tables as Unity Catalog managed tables or external…
- An analyst query against a partitioned Delta fact table filters `WHERE transaction_date = '2025-10-01' AND store_id = 'NYC-042'`. The table…
- A Silver layer Delta table is partitioned by `transaction_date` and a nightly maintenance job runs `OPTIMIZE ... ZORDER BY (customer_id)`…
- A data engineering team is migrating from external tables to Unity Catalog managed tables to reduce operational overhead. After the…
- A Databricks production Delta table has deletion vectors enabled (`delta.enableDeletionVectors = true`). The operations team notices that…
- An existing production Delta table is configured with Hive-style date partitioning (`PARTITIONED BY date`) and a nightly Z-order job…
- A PySpark job joins a 500 GB `transactions` fact table with a 2 GB `product_catalog` lookup table. The job is running slowly. A data…
Monitoring and Alerting
- You configure a job-level notification for Failure. A task fails but is retried and eventually succeeds, and you do not receive a failure…
- A teammate is testing a new SQL Alert definition using the alert preview UI, but the underlying query depends on a parameter. They notice…
- You want to share detailed query execution information with a teammate to help debug a performance regression. You both have access to the…
- A data engineer cannot query `system.query`- and `system.billing`-related system tables from a notebook. They get a permissions error even…
- Your team wants a lightweight script in CI that checks whether a specific Lakeflow Job run failed overnight and posts a summary to Slack…
- You need to programmatically determine whether a Lakeflow Spark Declarative Pipeline update is currently RUNNING, FAILED, or COMPLETED, and…
- You are the owner of a Unity Catalog-enabled Lakeflow Spark Declarative Pipeline and want to query its event log directly in SQL without…
Data Governance
- A data steward is applying tags to Unity Catalog securable objects to improve data discoverability. Which of the following statements about…
- A data governance team wants all users in the Databricks account to be able to discover tables registered in a newly created catalog called…
- A Unity Catalog administrator wants to allow a service principal to create tables in any schema that currently exists OR will be created in…
- A data engineer runs the following command: ```sql GRANT SELECT ON CATALOG main TO `analyst_team`; ``` A new table called…
Data Ingestion & Acquisition
- A Structured Streaming job reads from Kafka using `.option('startingOffsets', 'latest')` and writes to a Delta sink with a checkpoint…
- A streaming pipeline ingests events and uses `foreachBatch` to write the same micro-batch into two Delta tables (a raw table and an audit…
- A data engineering team ingests raw JSON and CSV drops landing every minute in a cloud object storage path. During peak hours, millions of…
- A downstream pipeline needs to process incremental changes from an upstream Delta table. The upstream table is NOT append-only: it can…
Data Modelling
- A data engineer is designing a star schema for a large analytical workload in Databricks. The central fact table `fact_orders` (500 GB…
- A data team is implementing a star-schema dimensional model for e-commerce analytics. A key dimension table `dim_customer` changes slowly…
- A data engineering team is building a large Delta Lake table and uses a `MERGE` operation nightly to upsert records from a daily CDC feed…
- A data engineering team enables automatic liquid clustering (`CLUSTER BY AUTO`) on a Unity Catalog managed Delta table using Databricks…
Data Sharing and Federation
- A provider wants to share live, read-only Delta tables from a Unity Catalog-enabled workspace to external consumers who will query using…
- You need to share a Unity Catalog-managed dataset with another organization that also uses a Unity Catalog-enabled Databricks workspace…
- A provider wants to share a Unity Catalog volume to a recipient. Which statement is correct about volume sharing in Delta Sharing?
Data Transformation, Cleansing, and Quality
- A classic job uses Auto Loader to ingest JSON files where new fields can appear without notice and some fields occasionally arrive with…
- A Lakeflow Spark Declarative Pipelines (DLT) pipeline ingests customer records. The team wants to enforce that `customer_id IS NOT NULL`…
- A Delta table `sales` contains `category`, `product_id`, and `revenue`. A report needs the top 3 products per category by total revenue…
- A PySpark job defines the following window spec for cumulative metrics: `w = Window.partitionBy('customer_id').orderBy('event_time')` and…
Debugging and Deploying
- A Lakeflow Spark Declarative Pipeline has a streaming flow ingesting from Apache Kafka but is falling progressively further behind, with…
- A data engineer needs to investigate why a Lakeflow Spark Declarative Pipeline update processed far fewer records than expected. They…
- An organization wants to set up a production Git folder in Databricks that tracks the `main` branch of a remote GitHub repository. The…
- A Databricks workspace team is choosing a CI/CD strategy. Option 1 is to use a production Git folder (updated via the Repos API on PR…
- A data engineer needs to identify which specific tasks within a multi-task Databricks job run failed, along with the start time, end time…
- A Databricks job run fails because a job parameter `--env` was mistakenly set to `staging` when the code requires `production` to connect…
Ensuring Data Security and Compliance
- A data engineer has a Lakeflow Spark Declarative Pipelines pipeline where a streaming table `clicks_bronze` reads from a Delta table source…
- A team is designing a row-level security solution using Unity Catalog row filters. A data engineer raises a concern about a legacy…
- A data engineering team implements GDPR compliance in a medallion architecture. After deleting user PII from the bronze layer tables, they…
- A data engineer has a Delta table with deletion vectors enabled. After processing a GDPR 'right-to-be-forgotten' request, they run: ```sql…
- A data governance team needs to store email addresses in a way that allows analysts to join datasets by user identity without ever seeing…
- A healthcare data team is preparing a dataset for statistical analysis. The dataset contains exact patient ages (e.g., 34, 67, 22). The…
Score it like the real exam
The same 60 questions, timed, with a section-by-section breakdown at the end. Free, no credit card.
Start the free DE Professional practice test →