COF-C03 practice question 2 of 10
At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
Full set: 1,126 questionsThe 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.
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.
- 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
Keep practicing
Take the free COF-C03 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other COF-C03 practice questions
- Question 1What is the primary purpose for configuring multiple Identity Providers, or IdPs, in Snow…
- Question 3Which commands are restricted in owner's rights stored procedures? (Select TWO).
- Question 4Which views are included in the DATA SHARING USAGE schema? (Select TWO).
- Question 5Snowflake's access control framework combines which models for securing data? (Select TWO…
- Question 6True or False: Loading data into Snowflake requires that source data files be no larger t…
- Question 7True or False: Fail-safe can be disabled within a Snowflake account.
