Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Certified Data Engineer Professional All Questions

View all questions & answers for the Certified Data Engineer Professional exam

Exam Certified Data Engineer Professional topic 1 question 44 discussion

Actual exam question from Databricks's Certified Data Engineer Professional
Question #: 44
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; the Delta cache may return records from previous versions of the table until the cluster is restarted.
  • 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.
  • E. No; files containing deleted records may still be accessible with time travel until a VACUUM command is used to remove invalidated data files.
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
kz_data
10 months, 2 weeks ago
Selected Answer: E
E is correct
upvoted 2 times
...
ervinshang
11 months, 1 week ago
Selected Answer: E
E is correct.
upvoted 2 times
...
alexvno
1 year ago
Selected Answer: E
Correct
upvoted 1 times
...
chokthewa
1 year, 1 month ago
E is correct.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...