CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #116
CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #116: Real Exam Question with Answer & Explanation
Sign in or unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to reveal the answer and full explanation for question #116. The question stem and answer options stay visible for context.
Question
The data governance team is reviewing user for deleting records for compliance with GDPR. The following logic has been implemented to propagate deleted requests from the user_lookup table to the user aggregate table. Assuming that user_id is a unique identifying key and that all users have requested deletion have been removed from the user_lookup table, which statement describes whether successfully executing the above logic guarantees that the records to be deleted from the user_aggregates table are no longer accessible and why?
Options
- ANo; files containing deleted records may still be accessible with time travel until a BACUM
- BYes; Delta Lake ACID guarantees provide assurance that the DELETE command successed fully
- CNo; the change data feed only tracks inserts and updates not deleted records.
- DNo; the Delta Lake DELETE command only provides ACID guarantees when combined with the
- EYes; the change data feed uses foreign keys to ensure delete consistency throughout the
Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to see the answer
You've previewed enough free CERTIFIED-DATA-ENGINEER-PROFESSIONAL questions. Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.