Why Time Travel enables data recovery in Snowflake - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

How does Time Travel help recover deleted data in Snowflake?

Snowflake's Time Travel feature allows you to access historical data. Which statement best explains how Time Travel enables data recovery?

A It creates a snapshot of the database only when a manual backup is triggered.

B It automatically backs up data to an external storage every hour.

C It keeps a copy of all data changes for a set period, allowing queries on past data states.

D It stores deleted data permanently in a separate archive that must be restored manually.

💡 Hint

Think about how you can query data as it was before a change.

Time Travel keeps track of all data changes for a configurable retention period. This allows users to query or restore data as it existed at any point within that period, enabling easy recovery from accidental deletes or updates.

❓ service_behavior

intermediate

What happens when you query a table using Time Travel in Snowflake?

You run a query on a Snowflake table using the AT clause to specify a past timestamp. What is the expected behavior?

A The query returns the table data as it existed exactly at the specified timestamp.

B The query returns the current data but adds a timestamp column showing the past time.

C The query fails because Time Travel only works for deleted tables, not queries.

D The query returns an empty result if the timestamp is older than 24 hours.

💡 Hint

Consider how Time Travel lets you see data from the past.

Using the AT clause with a timestamp lets you query the table as it was at that exact time, showing historical data within the retention period.

❓ Architecture

advanced

How does Snowflake's Time Travel architecture support data recovery without extra storage costs?

Snowflake uses a unique architecture for Time Travel. Which architectural feature allows Time Travel to enable data recovery efficiently?

A It stores only the changes (deltas) between data versions, not full copies of data.

B It duplicates the entire database every hour to a separate storage location.

C It requires users to manually save snapshots to enable recovery.

D It compresses all historical data into a single archive file updated daily.

💡 Hint

Think about how storing only differences can save space.

Snowflake stores only the changes between data versions (deltas) rather than full copies. This approach reduces storage needs while allowing reconstruction of past data states for recovery.

❓ security

advanced

What security consideration is important when using Time Travel for data recovery?

When recovering data using Time Travel, which security practice is essential to protect sensitive historical data?

A Disable Time Travel to prevent unauthorized access to old data versions.

B Allow all users to access Time Travel data for transparency.

C Encrypt only current data, as historical data is automatically secure.

D Ensure access controls and permissions apply equally to historical data accessed via Time Travel.

💡 Hint

Think about who can see past data versions.

Access controls must apply to historical data accessed through Time Travel to prevent unauthorized viewing or recovery of sensitive information.

✅ Best Practice

expert

What is the best practice for setting Time Travel retention period to balance recovery and cost?

Snowflake allows configuring the Time Travel retention period. Which option best balances data recovery needs and storage cost?

A Always set the retention period to the maximum allowed to keep all historical data indefinitely.

B Set the retention period to the minimum required by your recovery policy, avoiding unnecessary storage costs.

C Disable Time Travel and rely only on manual backups to reduce costs.

D Set retention to zero and enable continuous data replication instead.

💡 Hint

Consider cost vs. recovery needs.

Setting the retention period to the minimum needed ensures you can recover data within your policy while controlling storage costs. Longer retention increases costs without always adding value.