DBX-DEA Databricks · Databricks Data Engineer
Databricks Certified Data Engineer Associate. A full practice exam for the Databricks Data Engineer Associate across the whole exam guide: compute choices, Auto Loader, COPY INTO and Lakeflow Connect, PySpark and SQL transformations, gold-layer objects, Lakeflow Jobs tasks and triggers, Git folders and Declarative Automation Bundles, the Spark UI, Liquid Clustering, and Unity Catalog permissions, masking and table types.
Take the free Databricks Data Engineer Associate diagnostic10 questions, no card needed
3 questions from the free diagnostic, with answers and explanations.
A nightly load wrote bad rows into a Delta table. The team wants the table back exactly as it was before the load. Which Delta Lake feature makes this possible?
Answer: A (Time travel, with RESTORE TABLE)
Every Delta write is a new table version. RESTORE TABLE ... TO VERSION AS OF (or TIMESTAMP AS OF) returns the table to an earlier version.
JSON files land in a cloud storage folder all day. Each run must load only files it has not loaded before, add new columns when they appear, and never list the folder's history by hand. What should the data engineer use?
Answer: A (Auto Loader (cloudFiles) with a schema and checkpoint location)
Auto Loader tracks processed files in its checkpoint and, with a schema location, evolves the schema when new columns arrive.
Bronze table orders_raw contains exact re-sends of the same order. The silver table must keep one row per order_id. Which PySpark expression does this?
Answer: A (orders_raw.dropDuplicates(["order_id"]))
dropDuplicates with a column list keeps one row per key. distinct() takes no columns, groupBy().count() returns counts instead of rows, and dropna removes nulls.
Share of practice questions per skill area.
Build and run pipelines on the Databricks Data Intelligence Platform: Spark DataFrames, Delta Lake, Lakeflow pipelines and jobs, Unity Catalog governance, then production-grade design, testing and monitoring.
Yes. Create a free account and take the Databricks Data Engineer Associate free diagnostic: 10 questions across every skill area of the exam, with a study plan for the topics to work on. You can retake it as often as you like.
Each full practice test has 45 questions with a 90-minute timer, and you pass at 70%. There are 6 practice tests plus a harder challenge test, with 350 questions in total.
Single choice and exhibits (screenshots, diagrams and code), the same formats you meet on the real exam.
No. They are original questions written for ExamKite and mapped to the official Databricks exam guide, never copied from the real exam. Using leaked exam questions breaks the certification provider's exam rules and can get your certification revoked.
More answers in the full FAQ.
Start with the free diagnostic and get a study plan for the topics you miss.
