Explanation:
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.
Ultimate access to all questions.
No comments yet.
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’)