Snowflake SnowPro Certification Practice Test

What feature does Time Travel retention policy provide in Snowflake?

1. Instant data retrieval

2. Ability to recover historical data

3. Enhanced security controls

4. Data redundancy

The correct answer is: Ability to recover historical data

The Time Travel retention policy in Snowflake is designed to allow users to access and recover historical data. This feature enables users to view and restore data as it existed at any point within the retention period, which can span from a minimum of one day up to 90 days, depending on the account's settings. This capability is particularly useful for recovering data that may have been accidentally deleted or modified, as it provides a way to revert to a previous state of the database. This functionality enhances data management and operational resilience by ensuring that changes and deletions can be addressed swiftly, thereby minimizing potential data loss. It is a significant advantage for organizations that require robust data governance and compliance practices, facilitating audit trails and recovery processes when necessary.