SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ46

Data Storage and Processing

A Snowflake account has these parameters:

  1. MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level.
  2. DATA_RETENTION_TIME_IN_DAYS is set to 4 on database DB1 and to 6 on Schema1 in database DB1.
  3. DATA_RETENTION_TIME_IN_DAYS is set to 5 on database DB2 and to 8 on Schema2 in database DB2.

What is the result?

Explanation

For each object, the effective retention period is MAX(DATA_RETENTION_TIME_IN_DAYS, MIN_DATA_RETENTION_TIME_IN_DAYS). Therefore, DB1’s 4-day setting is raised to 5 days; Schema1 remains 6 days; DB2 remains 5 days; and Schema2 remains 8 days.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!