Question
You have an Azure Databricks workspace that is enabled for Unity Catalog.
You need to implement a data lifecycle and expiration solution that meets the following requirements:
Transaction logs and deleted data files that are older than 90 days must be removed from Delta tables to reclaim storage.
All the tables must remain available for querying during the cleanup process.
Administrative effort must be minimized.
What should you do for each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Data lifecycle control: delta.deletedFileRetentionDuration sets the threshold VACUUM uses to remove data files the current table version no longer references, so 90 days is the value that drives this cleanup. logRetentionDuration only controls how long table history is kept, and log files are removed automatically after checkpoints; it must also be at least as long as the deleted file retention. timeUntilArchived relates to archival rather than deletion, and a tag only adds metadata and removes nothing.
Expiration cleanup: VACUUM permanently removes unreferenced data files older than the retention threshold, and the current version of the table stays in place for queries. OPTIMIZE compacts files without purging expired ones, dropping and recreating makes the tables unavailable, and DELETE changes rows and creates more files to clean up.
