Question
You have an Azure Databricks workspace that is enabled for Unity Catalog and contains a managed Delta table named Table1. Table1 stores customer data.
You need to implement a data retention solution that meets the following requirements:
Deleted data must be retained for 30 days to support audits.
Deleted data that is older than 30 days must be removed permanently.
The solution must minimize administrative effort.
Which two properties should you configure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. delta.timeUntilArchived
- B. delta.enableDeletionVectors
- C. delta.logRetentionDuration Correct
- D. delta.deletedFileRetentionDuration Correct
- E. delta.autoOptimize.autoCompact
Explanation
Keeping a past table version available requires both its log and its data files, so both retention properties must be set to 30 days. delta.deletedFileRetentionDuration sets the threshold VACUUM uses to permanently remove unreferenced data files, and delta.logRetentionDuration controls how long table history is kept. Predictive optimization can run VACUUM automatically on Unity Catalog managed tables, which keeps administrative effort low. delta.timeUntilArchived concerns archival rather than removal, deletion vectors only change how deletes are recorded, and auto compaction merges small files.
