DBX-DEP Databricks · Databricks Data Engineer
Databricks Certified Data Engineer Professional. A full practice exam for the Databricks Data Engineer Professional across the whole exam guide: bundle project structure and dependencies, UDFs, Lakeflow pipelines and AUTO CDC, streaming tables versus materialized views, testing, Structured Streaming state, CDC connectors, OpenSharing and federation, VARIANT and AI functions, system tables and event logs, Liquid Clustering, deletion vectors and Change Data Feed, ABAC and data purging, permission inheritance, job repair and dimensional modeling.
Take the free Databricks Data Engineer Professional diagnostic10 questions, no card needed
3 questions from the free diagnostic, with answers and explanations.
Which pyspark.testing function checks that two DataFrames contain the same rows and schema in a unit test?
Answer: A (assertDataFrameEqual)
pyspark.testing.assertDataFrameEqual compares data and schema and reports differences. assertSchemaEqual compares schemas only.
A customer dimension must keep full history: when a customer's address changes in the CDC feed, the old row must be closed out and a new current row added. Change records can arrive out of order, and deletes are flagged with op = 'D'. Which Lakeflow pipeline definition fits?
Answer: A (AUTO CDC with KEYS, SEQUENCE BY the change time, STORED AS SCD TYPE 2)
AUTO CDC (formerly APPLY CHANGES) with SEQUENCE BY handles out-of-order changes, APPLY AS DELETE WHEN handles deletes, and SCD type 2 keeps history with start and end columns.
A partner company also uses Databricks with Unity Catalog. They need live read access to three of your tables without copying data or creating accounts in your workspace. What should you use?
Answer: A (Databricks-to-Databricks sharing (OpenSharing))
Databricks-to-Databricks sharing gives the recipient's metastore governed, read-only access to shared tables without copies or local accounts.
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 Professional 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 50 questions with a 100-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.
