SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ51

Implement disaster recovery, perform backups, and replicate data

A company has configured Snowflake replication between two Snowflake accounts, both running Snowflake Enterprise Edition. Replication applies to database APP_DB, which contains only one schema, APP_SCHEMA. The company’s Time Travel retention policy is currently 30 days in both accounts. An Administrator must extend the Time Travel retention policy to 60 days on the secondary database only.

How can this requirement be fulfilled?

Explanation

An explicit DATA_RETENTION_TIME_IN_DAYS setting at the secondary database level is not overwritten by replication from the primary database. The secondary database’s contained schema and objects inherit that 60-day database-level retention unless they have an explicit override. Snowflake Enterprise Edition permits a Time Travel retention period of up to 90 days for permanent databases, schemas, and tables.

Learn more

Community Discussion

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