Certified Data Engineer Professional Exam QuestionsBrowse all questions from this exam

Certified Data Engineer Professional Exam - Question 44


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?

Show Answer
Correct Answer: E

Delta Lake maintains versions of data and files for enabling time travel and ensuring ACID transactions. Even after executing a DELETE command, the deleted records remain in the older versions of the table until a VACUUM command is executed to remove them. Thus, files containing deleted records may still be accessible through time travel until they are permanently removed by performing a VACUUM operation.

Discussion

4 comments
Sign in to comment
ervinshangOption: E
Dec 25, 2023

E is correct.

kz_dataOption: E
Jan 11, 2024

E is correct

chokthewaOption: E
Oct 23, 2023

E is correct.

alexvnoOption: E
Nov 12, 2023

Correct