At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

The correct answer is A. Account. MIN_DATA_RETENTION_TIME_IN_DAYS is an account-level parameter in Snowflake that sets a floor on how low the DATA_RETENTION_TIME_IN_DAYS parameter can be set for any database, schema, or table within that account. Even if an object-level setting specifies 0 days of Time Travel…

Storage and Data Protection

Question

Options

AAccount
BDatabase
CSchema
DTable

How the community answered

(27 responses)

A
85% (23)
B
7% (2)
C
4% (1)
D
4% (1)

Explanation

MIN_DATA_RETENTION_TIME_IN_DAYS is an account-level parameter in Snowflake that sets a floor on how low the DATA_RETENTION_TIME_IN_DAYS parameter can be set for any database, schema, or table within that account. Even if an object-level setting specifies 0 days of Time Travel retention, it cannot go below the account-level minimum. This ensures that administrators can enforce a minimum Time Travel window across the entire account, preventing users from inadvertently disabling Time Travel for critical objects. Only account administrators can set this parameter.

Topics

#MIN_DATA_RETENTION_TIME_IN_DAYS#Account Parameters#Data Retention#Time Travel

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice