nerdexam
Snowflake

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…

Storage and Data Protection

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)
  • A
    96% (44)
  • B
    2% (1)
  • C
    2% (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

#Data Retention#Time Travel#Account Parameters#MIN_DATA_RETENTION_TIME_IN_DAYS

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice