Databricks Certified Data Engineer Associate Questions and Answers
200 questions organized by topic with detailed explanations
Databricks
DEA
200 questions
5 topics
Updated Jul 2026Databricks Intelligence Platform
20 questions8 easy8 medium4 hard~10% of exam
What are the two types of clusters available in Databricks?A Databricks account has three workspaces deployed in the same region. An administrator wants to apply a single governan...A data engineer needs to run an automated ETL notebook every night. To minimize cost, which compute configuration should...
Development and Ingestion
60 questions15 easy31 medium14 hard~30% of exam
A data engineer is troubleshooting a Structured Streaming pipeline that uses Auto Loader. The pipeline ran successfully ...A data engineer needs to extract data from a source table only where the `updated_at` timestamp is after the last pipeli...In the Databricks Lakehouse architecture, what is the recommended pattern for organizing data through successive stages ...
Data Processing & Transformations
62 questions14 easy32 medium16 hard~31% of exam
A data engineer is building a transformation that processes a `products` table containing a `tags` column of type `ARRAY...What does the `MERGE INTO` SQL statement do in Delta Lake?A data engineer writes the following Spark SQL to query a Delta table:\n\n```sql\nSELECT customer_id, SUM(amount) AS tot...
Productionizing Data Pipelines
36 questions8 easy18 medium10 hard~18% of exam
A data engineer is designing a Lakeflow Job with three tasks: Task A ingests data, Task B transforms it, and Task C vali...A data engineer wants to programmatically create and deploy Lakeflow Jobs as part of a CI/CD pipeline using infrastructu...A data engineering team stores their job notebooks in a Git repository. They want to ensure that each Lakeflow Job run u...
Data Governance & Quality
22 questions6 easy11 medium5 hard~11% of exam
What happens when a Unity Catalog managed table is dropped with `DROP TABLE`?A data engineer needs to grant a group of analysts `SELECT` access to all tables in a schema named `analytics` in the `p...A data engineer needs to register an existing Parquet dataset stored in an Azure Data Lake Storage Gen2 path as a querya...
All Questions
| # | Question | Topic | Difficulty |
|---|---|---|---|
| 1 | A data engineer is building a transformation that processes a `products` table containing a `tags` c... | Data Processing & Transformations | hard |
| 2 | What are the two types of clusters available in Databricks? | Databricks Intelligence Platform | easy |
| 3 | What does the `MERGE INTO` SQL statement do in Delta Lake? | Data Processing & Transformations | easy |
| 4 | A data engineer is designing a Lakeflow Job with three tasks: Task A ingests data, Task B transforms... | Productionizing Data Pipelines | medium |
| 5 | A data engineer writes the following Spark SQL to query a Delta table:\n\n```sql\nSELECT customer_id... | Data Processing & Transformations | medium |
Sign in to see all 200 questions
Create a free account to browse the questions included with the free plan.
Ready to test your knowledge?
Take a full Databricks Certified Data Engineer Associate practice test with timed exam simulation.
Start Practice Test