The following settings are configured:
THE MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level.
THE DATA_RETENTION_TIME_IN_DAYS is set to 2 at the object level.
For how many days will the data be retained at the object level?
The following settings are configured:
THE MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level.
THE DATA_RETENTION_TIME_IN_DAYS is set to 2 at the object level.
For how many days will the data be retained at the object level?
When both a minimum data retention time at the account level and a data retention time at the object level are configured, the greater value between the two settings is used. In this case, the MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5, and the DATA_RETENTION_TIME_IN_DAYS is set to 2. Therefore, the data will be retained for 5 days at the object level.
If there is a minimum retention time set for the account, and a retention time explicitly set on an object, the effective retention time is the greater of the two: MAX(DATA_RETENTION_TIME_IN_DAYS, MIN_DATA_RETENTION_TIME_IN_DAYS). https://docs.snowflake.com/en/release-notes/bcr-bundles/2023_04/bcr-928?utm_source=legacy&utm_medium=serp&utm_term=MIN_DATA_RETENTION_TIME_IN_DAYS
c is correct
Answer C