Answer-first summary for fast verification
Answer: ALTER TABLE table_name set TBLPROPERTIES (delta.deletedFileRetentionDuration= ‘interval 365 days’)
The correct command to set the retention duration for deleted files in a Delta table is `ALTER TABLE table_name SET TBLPROPERTIES (delta.deletedFileRetentionDuration= ‘interval 365 days’)`. This command allows you to specify how long deleted files should be retained before they are eligible for VACUUM. The `TBLPROPERTIES` clause is used to set or update key-value pairs as table properties, which can include retention settings. For more details, refer to the documentation on table properties and table options in Databricks SQL.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
To comply with an internal audit team's requirement that certain tables maintain a minimum of 365 days of data for compliance, which setting should be implemented to override the default VACUUM threshold of 7 days?
A
MODIFY TABLE table_name set TBLPROPERTY (delta.maxRetentionDays = ‘interval 365 days’)
B
ALTER TABLE table_name set EXENDED TBLPROPERTIES (delta.vaccum.duration= ‘interval 365 days’)
C
ALTER TABLE table_name set TBLPROPERTIES (delta.deletedFileRetentionDuration= ‘interval 365 days’)
D
ALTER TABLE table_name set EXENDED TBLPROPERTIES (delta.deletedFileRetentionDuration= ‘interval 365 days’)
No comments yet.