SnowPro Advanced: Architect — Question 188

A Snowflake account has the following parameters:

1. MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level.
2. DATA_RETENTION_TIME_IN_DAYS is set to 4 on database DB1, and 6 on Schema1 in Database DB1.
3. DATA_RETENTION_TIME_IN_DAYS is set to 5 on Database DB2, and 8 on Schema2 in Database DB2.

What will be the result?

Answer options

• A. Database DB1 and Schema1 will be retained for 5 days. Database DB2 and Schema2 will be retained for 5 days.
• B. Database DB1 and Schema1 will be retained for 4 days. Database DB2 and Schema2 will be retained for 5 days.
• C. Database DB1 will be retained for 4 days and Schema1 will be retained for 6 days. Database DB2 will be retained for 5 days and Schema2 will be retained for 8 days.
• D. Database DB1 will be retained for 5 days and Schema1 will be retained for 6 days. Database DB2 will be retained for 5 days and Schema2 will be retained for 8 days.

Correct answer: D

Explanation

The correct answer is D because the account-level MIN_DATA_RETENTION_TIME_IN_DAYS is 5, but since Schema1 has a higher DATA_RETENTION_TIME_IN_DAYS of 6, it overrides the account-level setting. For Database DB2 and Schema2, their respective retention settings of 5 and 8 days are retained as they do not conflict with the account-level setting. The other options either misstate the retention periods or do not follow the correct hierarchy of retention settings.