Exam Certified Data Engineer Professional topic 1 question 192 discussion

Actual exam question from Databricks's Certified Data Engineer Professional

Question #: 192
Topic #: 1

[All Certified Data Engineer Professional Questions]

A Delta Lake table in the Lakehouse named customer_churn_params is used in churn prediction by the machine learning team. The table contains information about customers derived from a number of upstream sources. Currently, the data engineering team populates this table nightly by overwriting the table with the current valid values derived from upstream data sources.

Immediately after each update succeeds, the data engineering team would like to determine the difference between the new version and the previous version of the table.

Given the current implementation, which method can be used?

A. Execute a query to calculate the difference between the new version and the previous version using Delta Lake’s built-in versioning and lime travel functionality.
B. Parse the Delta Lake transaction log to identify all newly written data files.
C. Parse the Spark event logs to identify those rows that were updated, inserted, or deleted.
D. Execute DESCRIBE HISTORY customer_churn_params to obtain the full operation metrics for the update, including a log of all records that have been added or modified.

Show Suggested Answer

Suggested Answer: A 🗳️

by KadELbied at May 2, 2025, 7 p.m.

Comments

Submit Cancel

stopthisnow

1 day, 10 hours ago

Selected Answer: A

A - there lime is actually time.... D makes no sense

upvoted 1 times

...

RajeshMP2023

4 months ago

Selected Answer: D

there is no lime history , D looks suitable

upvoted 1 times

...