A company has implemented Snowflake replication between two Snowflake accounts, both of which are running on a Snowflake Enterprise edition. The replication is for the database APP_DB containing…

Question

Options

• ASet the data retention policy on the secondary database to 60 days.
• BSet the data retention policy on the schemas in the secondary database to 60 days.
• CSet the data retention policy on the primary database to 30 days and the schemas to 60 days.
• DSet the data retention policy on the primary database to 60 days.

• A
  79% (22)
• B
  7% (2)
• C
  4% (1)
• D
  11% (3)

Explanation

According to the Replication considerations documentation, the Time Travel retention period for a secondary database can be different from the primary database. The retention period can be set at the database, schema, or table level using the DATA_RETENTION_TIME_IN_DAYS parameter. Therefore, to extend the Time Travel retention policy to 60 days on the secondary database only, the best option is to set the data retention policy on the secondary database to 60 days using the ALTER DATABASE command.

No community discussion yet for this question.