COF-C02 · Question #544
At what level is the MIN_DATA_RETENSION_TIME_IN_DAYS parameter set?
The correct answer is A. Account. MIN_DATA_RETENTION_TIME_IN_DAYS is an account-level parameter. It establishes a floor - a minimum number of days that Time Travel data must be retained - and overrides any lower value set at the object level (database, schema, or table). You cannot set…
Question
At what level is the MIN_DATA_RETENSION_TIME_IN_DAYS parameter set?
Options
- AAccount
- BDatabase
- CSchema
- DTable
How the community answered
(46 responses)- A96% (44)
- B2% (1)
- C2% (1)
Explanation
MIN_DATA_RETENTION_TIME_IN_DAYS is an account-level parameter. It establishes a floor - a minimum number of days that Time Travel data must be retained - and overrides any lower value set at the object level (database, schema, or table). You cannot set MIN_DATA_RETENTION_TIME_IN_DAYS at the database, schema, or table level; those levels only support DATA_RETENTION_TIME_IN_DAYS (without the 'MIN_' prefix).
Topics
Community Discussion
No community discussion yet for this question.