Logo ExamsQA
Exit
Official Bank 0/215

Databricks Certified Data Engineer Professional (Data Engineer Professional) - Databricks Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
215 Total Questions
1
Question
What is true for Delta Lake?
Options
A Primary and foreign key constraints can be leveraged to ensure duplicate values are never entered into a dimension table.
B Views in the Lakehouse maintain a valid cache of the most recent versions of source tables at all times.
C Z-ORDER can only be applied to numeric values stored in Delta Lake tables.
D Delta Lake automatically collects statistics on the first 32 columns of each table, which are leveraged in data skipping based on query filters.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
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:

Exhibit

Which command allows manual confirmation that these three requirements have been met?
Options
A SHOW TABLES dev
B DESCRIBE DETAIL dev.pii test
C DESCRIBE EXTENDED dev.pii test
D SHOW TBLPROPERTIES dev.pii test
E DESCRIBE HISTORY dev.pii test
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
A Delta Lake table was created with the below query:

Exhibit

Realizing that the original query had a typographical error, the below code was executed: ALTER TABLE prod.sales_by_stor RENAME TO prod.sales_by_store Which result will occur after running the second command?
Options
A A new Delta transaction log Is created for the renamed table.
B The table name change is recorded in the Delta transaction log.
C The table reference in the metastore is updated and no data is changed.
D All related files and metadata are dropped and recreated in a single ACID transaction.
E The table reference in the metastore is updated and all data files are moved.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
A data engineer is designing an append-only pipeline that needs to handle both batch and streaming data in Delta Lake. The team wants to ensure that the streaming component can efficiently track

which data has already been processed.

Which configuration should be set to enable this?
Options
A partitionBy
B overwriteSchema
C checkpointLocation
D mergeSchema
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
How are the operational aspects of Lakeflow Declarative Pipelines different from Spark Structured Streaming?
Options
A Lakeflow Declarative Pipelines automatically handle schema evolution, while Structured Streaming always requires manual schema management.
B Lakeflow Declarative Pipelines manage the orchestration of multi-stage pipelines automatically,
while Structured Streaming requires external orchestration for complex dependencies.
C Lakeflow Declarative Pipelines can write to Delta Lake format, while Structured Streaming cannot.
D Structured Streaming can process continuous data streams, while Lakeflow Declarative Pipelines cannot.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.