Free Certified Data Engineer Professional Exam Questions and Answers

Last updated: September 8, 2026

Provider

Databricks

Questions in our bank

1000+

Free to read

First 10, with answers

Official page

Official Exam website

Our test mode duration & pass mark

130 mins · 70%

Verified answers

Reviewed weekly

Recommended: Switch to Test Mode to start a practice test that simulates the real exam experience.

1. Question #1

   A junior data engineer is migrating a workload from a relational database system to the Databricks Lakehouse. The source system uses a star schema, leveraging foreign key constrains and multi-table inserts to validate records on write. Which consideration will impact the decisions made by the engineer while migrating this workload?

   • A. All Delta Lake transactions are ACID compliance against a single table, and Databricks does not enforce foreign key constraints.
   • B. Databricks only allows foreign key constraints on hashed identifiers, which avoid collisions in highly-parallel writes.
   • C. Foreign keys must reference a primary key field; multi-table inserts must leverage Delta Lake's upsert functionality.
   • D. Committing to multiple tables simultaneously requires taking out multiple table locks and can lead to a state of deadlock.
   Reveal Answer

2. Question #2

   The data engineering team is migrating an enterprise system with thousands of tables and views into the Lakehouse. They plan to implement the target architecture using a series of bronze, silver, and gold tables. Bronze tables will almost exclusively be used by production data engineering workloads, while silver tables will be used to support both data engineering and machine learning workloads. Gold tables will largely serve business intelligence and reporting purposes. While personal identifying information (PII) exists in all tiers of data, pseudonymization and anonymization rules are in place for all data at the silver and gold levels. The organization is interested in reducing security concerns while maximizing the ability to collaborate across diverse teams. Which statement exemplifies best practices for implementing this system?

   • A. Isolating tables in separate databases based on data quality tiers allows for easy permissions management through database ACLs and allows physical
   • B. Because databases on Databricks are merely a logical construct, choices around database organization do not impact security or discoverability in the
   • C. Storinq all production tables in a single database provides a unified view of all data assets available throughout the Lakehouse, simplifying discoverability by
   • D. Working in the default Databricks database provides the greatest security when working with managed tables, as these will be created in the DBFS root.
   Reveal Answer

3. Question #3

   The data governance team has instituted a requirement that all tables containing Personal Identifiable Information (PH) must be clearly annotated. This includes adding column comments, table comments, and setting the custom table property "contains_pii" = true. The following SQL DDL statement is executed to create a new table: Which command allows manual confirmation that these three requirements have been met?

   • A. DESCRIBE EXTENDED dev.pii test
   • B. DESCRIBE DETAIL dev.pii test
   • C. SHOW TBLPROPERTIES dev.pii test
   • D. DESCRIBE HISTORY dev.pii test
   Reveal Answer

4. Question #4

   A data engineer, User A, has promoted a new pipeline to production by using the REST API to programmatically create several jobs. A DevOps engineer, User B, has configured an external orchestration tool to trigger job runs through the REST API. Both users authorized the REST API calls using their personal access tokens. Which statement describes the contents of the workspace audit logs concerning these events?

   • A. Because the REST API was used for job creation and triggering runs, a Service Principal will be automatically used to identity these events.
   • B. Because User B last configured the jobs, their identity will be associated with both the job creation events and the job run events.
   • C. Because these events are managed separately, User A will have their identity associated with the job creation events and User B will have their identity
   • D. Because the REST API was used for job creation and triggering runs, user identity will not be captured in the audit logs.
   Reveal Answer

5. Question #5

   An upstream system is emitting change data capture (CDC) logs that are being written to a cloud object storage directory. Each record in the log indicates the change type (insert, update, or delete) and the values for each field after the change. The source table has a primary key identified by the field pk_id. For auditing purposes, the data governance team wishes to maintain a full record of all values that have ever been valid in the source system. For analytical purposes, only the most recent value for each record needs to be recorded. The Databricks job to ingest these records occurs once per hour, but each individual record may have changed multiple times over the course of an hour. Which solution meets these requirements?

   • A. Create a separate history table for each pk_id resolve the current state of the table by running a union all filtering the history tables for the most recent state.
   • B. Use merge into to insert, update, or delete the most recent entry for each pk_id into abronze table, then propagate all changes throughout the system.
   • C. Iterate through an ordered set of changes to the table, applying each in turn; rely on Delta Lake's versioning ability to create an audit log.
   • D. Use Delta Lake's change data feed to automatically process CDC data from an external system, propagating all changes to all dependent tables in the
   Reveal Answer

6. Question #6

   A Delta Lake table representing metadata about content from user has the following schema: Based on the above schema, which column is a good candidate for partitioning the Delta Table?

   • A. Date
   • B. Post_id
   • C. User_id
   • D. Post_time
   Reveal Answer

7. Question #7

   The view updates represents an incremental batch of all newly ingested data to be inserted or updated in the customers table. The following logic is used to process these records. Which statement describes this implementation?

   • A. The customers table is implemented as a Type 3 table; old values are maintained as a new column alongside the current value.
   • B. The customers table is implemented as a Type 2 table; old values are maintained but marked as no longer current and new values are inserted.
   • C. The customers table is implemented as a Type 0 table; all writes are append only with no changes to existing values.
   • D. The customers table is implemented as a Type 1 table; old values are overwritten by new values and no history is maintained.
   Reveal Answer

8. Question #8

   What is the primary purpose of Delta Lake in Databricks?

   • A. Data versioning
   • B. Data visualization
   • C. Data mining
   • D. Data replication
   Reveal Answer

9. Question #9

   When performing a transformation using Apache Spark, which action is used to persist data?

   • A. collect
   • B. cache
   • C. filter
   • D. select
   Reveal Answer

10. Question #10

    In Databricks, which feature helps to automate the processing of data based on specific triggers?

    • A. Notebooks
    • B. Workflows
    • C. Libraries
    • D. Clusters
    Reveal Answer