Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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’)
