Exam Certified Data Engineer Professional topic 1 question 216 discussion

Actual exam question from Databricks's Certified Data Engineer Professional

Question #: 216
Topic #: 1

[All Certified Data Engineer Professional Questions]

The data governance team is reviewing code used for deleting records for compliance with GDPR. They note the following logic is used to delete records from the Delta Lake table named users.

Assuming that user_id is a unique identifying key and that delete_requests contains all users that have requested deletion, which statement describes whether successfully executing the above logic guarantees that the records to be deleted are no longer accessible and why?

A. Yes; Delta Lake ACID guarantees provide assurance that the DELETE command succeeded fully and permanently purged these records.
B. No; files containing deleted records may still be accessible with time travel until a VACUUM command is used to remove invalidated data files.
C. Yes; the Delta cache immediately updates to reflect the latest data files recorded to disk.
D. No; the Delta Lake DELETE command only provides ACID guarantees when combined with the MERGE INTO command.

Show Suggested Answer

Suggested Answer: B 🗳️

by KadELbied at May 5, 2025, 3:50 p.m.

Comments

Submit Cancel

KadELbied

1 month, 2 weeks ago

Selected Answer: B

suretly B

upvoted 1 times

...