Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Exam Databricks-Certified-Professional-Data-Engineer All Questions
Exam Databricks-Certified-Professional-Data-Engineer All Questions

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

Databricks Certification Databricks-Certified-Professional-Data-Engineer Question # 31 Topic 4 Discussion

Databricks-Certified-Professional-Data-Engineer Exam Topic 4 Question 31 Discussion:
Question #: 31
Topic #: 4

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.

Databricks-Certified-Professional-Data-Engineer Question 31

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?


A.

No: files containing deleted records may still be accessible with time travel until a BACUM command is used to remove invalidated data files.


B.

Yes: Delta Lake ACID guarantees provide assurance that the DELETE command successed fully and permanently purged these records.


C.

No: the change data feed only tracks inserts and updates not deleted records.


D.

No: the Delta Lake DELETE command only provides ACID guarantees when combined with the MERGE INTO command


Get Premium Databricks-Certified-Professional-Data-Engineer Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.