Time Travel

Question 1

What tasks can be done via Time Travel

Answer 1

Restoring data related objects (tables, schemas, and databases) that might have been deleted accidentally or on purpose
Duplicating and backing up data from key points in the past
Querying data in the past that has since been updated or deleted
Analyzing data usage/manipulation over specific periods of time

Question 2

How do you query data using time travel

Answer 2

select from table <table> at | before

Question 3

How do you create a new object using time travel

Answer 3

create table …. clone …. at | before
create schema …. clone … at | before
create database … clone … at |before

Question 4

How do you bring back a deleted object using time travel

Answer 4

undrop database …
undrop schema …
undrop table …

Question 5

What is the standard retention period automatically enabled on all accounts

Answer 5

1 day (24 hours)

Question 6

T/F for the standard and enterprise accounts, the retention period can be set to 0

Answer 6

True

Question 7

For permanent databases, schemas, and tables, what is the retention period that can be set

Answer 7

0 - 90 days

Question 8

When the retention period ends for an object, the historical data is moved in to…

Answer 8

Snowflake Fail Safe

Question 9

Once objects are moved into fail safe, what options are no longer available

Answer 9

Historical data is no longer available for querying
Past objects can no longer be cloned
Past objects that were cloned can no longer be restored

Question 10

What snowflake editions allow for time travel beyond 1 day

Answer 10

Enterprise

Question 11

Which of the following ALTER commands will impact a column’s availability in Time Travel?
A. ALTER TABLE … SET DATA TYPE …
B. ALTER TABLE … RENAME COLUMN …
C. ALTER TABLE … SET NOT NULL …
D. ALTER TABLE … DROP COLUMN …

Answer 11

A.

Question 12

What is the param to set the time travel number of days

Answer 12

DATA_RETENTION_TIME_IN_DAYS

Question 13

How is the retention days for an object determined when MIN_DATA_RETENTION_TIME_IN_DAYS is set

Answer 13

MAX(DATA_RETENTION_TIME_IN_DAYS, MIN_DATA_RETENTION_TIME_IN_DAYS)

Question 14

T/F Time Travel can be disabled on the account level

Answer 14

False - It can only be set to 0 Days retention. This can be overridden at the object level

Question 15

T/F when a database is dropped, the retention periods for the schema and the tables are not honored if they are different

Answer 15

True. If you want them to be honored, they have to be dropped before the entire database

Question 16

What is the purpose of fail-safe

Answer 16

ensures historical data is protected in the event of a system failure or other event. It provides a 7 day period during which historical data can be recoverable by Snowflake.

Question 17

When does the fail safe period begin

Answer 17

immediately after the time travel period ends

Question 18

T/F Fail Safe is a means for accessing historical data after the Time Travel retention period has ended.

Answer 18

False. It is only used by Snowflake to recover data that may have been lost or damaged due to extreme operational failures