
Explanation:
According to Snowflake documentation and the community discussion consensus, when both MIN_DATA_RETENTION_TIME_IN_DAYS (account level) and DATA_RETENTION_TIME_IN_DAYS (object level) are set, the effective retention time is the greater of the two values. In this case, MIN_DATA_RETENTION_TIME_IN_DAYS = 5 and DATA_RETENTION_TIME_IN_DAYS = 2, so the maximum value is 5. The community discussion shows 100% agreement on answer C, with the highest upvoted comment providing the correct formula: MAX(DATA_RETENTION_TIME_IN_DAYS, MIN_DATA_RETENTION_TIME_IN_DAYS). This ensures data protection by enforcing the minimum retention requirement set at the account level.
Given that MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level and DATA_RETENTION_TIME_IN_DAYS is set to 2 at the object level, for how many days will the data in the object be retained?
A
2
B
3
C
5
D
7
No comments yet.