Why Time Travel enables data recovery in Snowflake - Quick Recap

Recall & Review

beginner

What is Time Travel in Snowflake?

Time Travel is a feature in Snowflake that lets you access historical data at any point within a defined retention period. It helps you recover data that was changed or deleted.

beginner

How does Time Travel help recover deleted data?

Time Travel keeps snapshots of data before changes. If data is deleted, you can query the snapshot from before deletion and restore it.

intermediate

What is the default retention period for Time Travel in Snowflake?

The default retention period is 1 day (24 hours), but it can be extended up to 90 days depending on your Snowflake edition and settings.

intermediate

Why is Time Travel considered safer than manual backups?

Time Travel automatically keeps data history without extra work. It allows quick recovery without restoring from external backups, reducing downtime and errors.

beginner

Can Time Travel recover data after a long period?

Only if the data change is within the retention period. After that, data history is removed and cannot be recovered using Time Travel.

What does Snowflake's Time Travel feature allow you to do?

A Encrypt data at rest

B Automatically delete old data

C Access past versions of data within a retention period

D Create new databases

Time Travel lets you access historical data snapshots within a set retention period.

What is the default Time Travel retention period in Snowflake?

A 1 day

B 90 days

C 30 days

D 7 days

By default, Snowflake retains data history for 1 day (24 hours).

If data was deleted 2 days ago, can Time Travel recover it with default settings?

A No, Time Travel does not recover deleted data

B Yes, always

C Yes, but only if manually backed up

D No, because default retention is 1 day

Default retention is 1 day, so data deleted 2 days ago is not recoverable via Time Travel.

Why is Time Travel useful compared to manual backups?

A It requires no extra backup steps and allows quick recovery

B It deletes data faster

C It encrypts data automatically

D It creates more storage space

Time Travel automatically keeps data history, making recovery faster and easier than manual backups.

What happens to data history after the Time Travel retention period ends?

A It is archived indefinitely

B It is permanently removed and cannot be recovered

C It is moved to a backup server

D It is encrypted for security

After the retention period, data history is deleted and cannot be recovered using Time Travel.

Explain how Snowflake's Time Travel feature enables data recovery.

Think about how you can 'go back in time' to see old data versions.

Describe the limitations of Time Travel for data recovery in Snowflake.

Consider what happens when the 'time window' closes.