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?

Real Exam

Delete the requested data from the Delta table using the DELETE command.

4.9%

Apply the VACUUM command over the Delta table with the default retention period.

9.8%

First, delete the requested data using the DELETE command, then apply the VACUUM command with the default retention period.

9.8%

First, delete the requested data using the DELETE command, then apply the VACUUM command with a retention period of 0 hours.

57.3%

First, delete the requested data using the DELETE command, then apply the VACUUM command with a retention period of 24 hours.

18.3%

Databricks Certified Data Engineer - Professional