Answer-first summary for fast verification
Answer: First, delete the requested data using the `DELETE` command, then apply the `VACUUM` command with a retention period of 0 hours.
The correct approach involves two steps: first, deleting the data with the `DELETE` command, and then using the `VACUUM` command with a 0-hour retention period. This ensures the data is permanently deleted and cannot be recovered, bypassing Delta's time travel feature. Other options either fail to permanently delete the data or use retention periods that allow recovery.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
To comply with their country’s privacy act, a mobile company must ensure that the data of users who requested to cancel their SIM card in the last 24 hours is permanently deleted and unrecoverable. The company uses Delta tables with default settings for storing user data. What is the correct method for the data engineer to achieve this?
A
Delete the requested data from the Delta table using the DELETE command.
B
Apply the VACUUM command over the Delta table with the default retention period.
C
First, delete the requested data using the DELETE command, then apply the VACUUM command with the default retention period.
D
First, delete the requested data using the DELETE command, then apply the VACUUM command with a retention period of 0 hours.
E
First, delete the requested data using the DELETE command, then apply the VACUUM command with a retention period of 24 hours.