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

Become Databricks Certified with updated Databricks-Certified-Professional-Data-Engineer exam questions and correct answers

Page: 1 / 50

Total 247 Questions | Updated On: Mar 26, 2025

Add To Cart

Question 1

The data engineering team maintains the following code:

Databricks-Certified-Professional-Data-Engineer-page61-image9

Assuming that this code produces logically correct results and the data in the source tables has been de-duplicated and validated, which statement describes what will occur when this code is executed?

A : A batch job will update the enriched_itemized_orders_by_account table, replacing only those rows that have different values than the current version of the table, using accountID as the primary key.

B : The enriched_itemized_orders_by_account table will be overwritten using the current valid version of data in each of the three tables referenced in the join logic.

C : An incremental job will leverage information in the state store to identify unjoined rows in the source tables and write these rows to the enriched_iteinized_orders_by_account table.

D : An incremental job will detect if new rows have been written to any of the source tables; if new rows are detected, all results will be recalculated and used to overwrite the enriched_itemized_orders_by_account table

E : No computation will occur until enriched_itemized_orders_by_account is queried; upon query materialization, results will be calculated using the current valid version of data in each of the three tables referenced in the join logic.

Answer: B

Question 2

A data engineer is analyzing a Spark job via the Spark UI. They have the following summary metrics for 27 completed tasks in a particular stage

Which conclusion can the data engineer draw from the above statistics ?

A : All task are operating over partitions with even amounts of data

B : All task are operating over empty or near empty partitions

C : All tasks are operating over partitions with larger skewed amounts of data.

D : Number of tasks are operating over partitions with larger skewed amounts of data.

E : Number of tasks are operating over empty or near empty partitions

Answer: D

Question 3

The DevOps team has configured a production workload as a collection of notebooks scheduled to run daily using the Jobs UI. A new data engineering hire is onboarding to the team and has requested access to one of these notebooks to review the production logic. What are the maximum notebook permissions that can be granted to the user without allowing accidental changes to production code or data?

A : n Manage

B : n Edit

C : permissions

D : n Read

E : n Run

Answer: D

Question 4

Where in the Spark UI can one diagnose a performance problem induced by not leveraging predicate pushdown?

A : In the Executor’s log file, by grepping for "predicate push-down"

B : In the Stage’s Detail screen, in the Completed Stages table, by noting the size of data read from the Input column

C : In the Storage Detail screen, by noting which RDDs are not stored on disk

D : In the Delta Lake transaction log. by noting the column statistics

E : In the Query Detail screen, by interpreting the Physical Plan

Answer: E

Question 5

Which of the following statements regarding the retention policy of Delta lake CDF is correct ?

A : Running the VACUUM command on the table deletes CDF data as well

B : Running the VACUUM command on the table does not deletes CDF data

C : Running the VACUUM command on the table does not deletes CDF data unless CASCADE clause is set to true

D : CDF data files can be purged by running VACUUM CHANGES command

E : CDF data files can never be permanently purged from Delta Lake

Answer: A

Page: 1 / 50

Total 247 Questions | Updated On: Mar 26, 2025

Add To Cart