Snowflake SnowPro Certification Practice Test

How far back does Time Travel protection go in Snowflake?

1. 30 days

2. 60 days

3. 90 days

4. 120 days

The correct answer is: 90 days

Time Travel in Snowflake allows users to access historical data and perform actions such as querying data as of a specific time or restoring objects to a previous state. The duration for which this functionality is available depends on the account's edition but typically provides a retention period of up to 90 days for standard accounts. This means that users can look back and retrieve data that was available up to 90 days prior to the current date. This feature is particularly useful for recovering from accidental deletions, troubleshooting issues, or analyzing past data states without needing a separate backup system. The other choices represent durations that exceed the standard 90-day limit for Time Travel, making them unfeasible in this context. Depending on the organization's needs and the specific features of their Snowflake account, administrators can set this duration, but the default maximum is 90 days for most scenarios.