Answer: 5

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.

Author: LeetQuiz Editorial Team