Databricks Data Engineer Professional Practice Questions - Databricks Certified Data Engineer Professional Exam - Databricks Data Engineer Professional Practice Questions - Databricks Certified Data Engineer Professional Exam

Question 1

A silver-layer SQL transform must retain exactly one latest order record per `order_id` using `updated_at`. Which Spark SQL pattern is the most reliable?

GROUP BY `order_id` and keep `MAX(updated_at)` without returning the full row Use `ROW_NUMBER()` over `PARTITION BY order_id ORDER BY updated_at DESC` and filter to `rn = 1` Use `DISTINCT order_id` after selecting all columns Sort the table by `updated_at` and apply `LIMIT 1`

Correct Answer:

Use `ROW_NUMBER()` over `PARTITION BY order_id ORDER BY updated_at DESC` and filter to `rn = 1`

Question 2

You need to classify rows with a few regex-based rules in PySpark and keep the job optimizable by Catalyst. What should you do?

Implement the logic with a Python UDF Convert the DataFrame to pandas first Use built-in column expressions such as `when`, `regexp_extract`, and `rlike` Collect the data to the driver and loop in Python

Correct Answer:

Use built-in column expressions such as `when`, `regexp_extract`, and `rlike`

Question 3

In Lakeflow Declarative Pipelines, when should a dataset be modeled as a streaming table instead of a materialized view?

When the source is append-oriented or streaming and the target should be updated incrementally When every refresh should fully recompute the dataset from scratch Only when the target is stored outside Unity Catalog Only when the table is smaller than 1 GB

Correct Answer:

When the source is append-oriented or streaming and the target should be updated incrementally

Question 4

A structured streaming job writes to Delta through `foreachBatch`. The job may be restarted after failures, and duplicate output must be avoided. Which design is best?

Write in append mode without a checkpoint Collect the micro-batch to the driver before writing Delete the target and replay the full source after every restart Use a stable checkpoint and make each micro-batch idempotent, for example with `MERGE` on a business key

Correct Answer:

Use a stable checkpoint and make each micro-batch idempotent, for example with `MERGE` on a business key

Question 5

A CDC feed contains operation codes `I`, `U`, and `D`. Which `MERGE` logic is required to correctly apply deletes into a Delta target?

Overwrite the target table on every batch Add a `WHEN MATCHED AND op = 'D' THEN DELETE` clause Ignore delete rows and rely on `VACUUM` Union source rows to the target and run `DROP DUPLICATES`

Correct Answer:

Add a `WHEN MATCHED AND op = 'D' THEN DELETE` clause

Exam overview

About this Exam

Prepare with the Databricks Data Engineer Professional Practice Questions - Databricks Certified Data Engineer Professional Exam practice quiz. This question bank includes 100 questions covering table, data, delta, databricks, and need. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

Databricks Data Engineer Professional Practice Questions - Databricks Certified Data Engineer Professional Exam

This practice set contains 100 questions from the matching question bank and focuses on table, data, delta, databricks, and need. Work through each question carefully, review the provided solutions, and revisit topics that need more study before your next attempt.

This is an independent study resource intended for practice and review; it is not an official examination or an endorsement by any organization named in the title.

Quiz information

Frequently Asked Questions

The complete question count is available after full access is unlocked.

No fixed duration is currently configured for this quiz.

Question explanations are included where they are available in the quiz content, helping you review the reasoning after answering.

Yes. You can retake the practice test again as you continue studying during your available access period.

After your access is confirmed, you can continue into the complete practice exam from this quiz flow.

Unless explicitly stated otherwise, this page provides independent practice material for study and exam preparation and is not the official examination itself.

Correct Answer:

Correct Answer:

Correct Answer:

Correct Answer:

Correct Answer:

About this Exam

Additional Information

Databricks Data Engineer Professional Practice Questions - Databricks Certified Data Engineer Professional Exam

Frequently Asked Questions

Related Questions

ISC2 Certified in Cybersecurity Practice Exam

10th Brigade Engineer Battalion (10BEB) Board Practice Exam

2nd Class Power Engineering (2A1) Practice Exam

2nd Class Power Engineering 2A3 Practice Exam

2nd Class Power Engineering (2B1) Practice Exam

2nd Class Power Engineering 2B2 Practice Exam