COF-C03 practice question 2 of 10

At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

Full set: 1,126 questions
Answer options
A: Account Correct answer
B: Database
C: Schema
D: Table
Correct Answer:
A. Account
Explanation

The MINDATARETENTIONTIMEINDAYS parameter is an account-level setting available for Enterprise Edition (and higher) accounts. Its purpose is to enforce a minimum Time Travel retention period for all databases, schemas, and tables within the account. This ensures that no object can have its DATARETENTIONTIMEINDAYS set to a value lower than this account-wide minimum, which is critical for compliance and data governance. This parameter can only be set by a user with the ACCOUNTADMIN role.

Why Incorrect

B. Database: The DATARETENTIONTIMEINDAYS parameter can be set at the database level, but not the MINDATARETENTIONTIMEINDAYS parameter.
C. Schema: The DATARETENTIONTIMEINDAYS parameter can be set at the schema level, but not the MINDATARETENTIONTIMEINDAYS parameter.
D. Table: The DATARETENTIONTIMEINDAYS parameter can be set at the table level, but not the MINDATARETENTIONTIMEINDAYS parameter.

References

- Snowflake Documentation. (n.d.). MINDATARETENTIONTIMEINDAYS. In Object Parameters. Retrieved from https://docs.snowflake.com/en/sql-reference/parameters#min-data-retention-time-in-days

- Snowflake Documentation. (n.d.). Specifying the Data Retention Period for an Object. In Understanding & Using Time Travel. Retrieved from https://docs.snowflake.com/en/user-guide/data-time-travel#specifying-the-data-retention-period-for-an-object

Scroll to Top