2025 Time Travel and Fail Safe

Question 1

In a time travel statement, how can you reference the historical data?

Answer 1

TIMESTAMP
OFFSET
STATEMENT

Question 2

What can the undrop statement be used for

Answer 2

TABLES
SCHEMAS
DATABASES

Question 3

What table types do not have a Fail-Safe Period

Answer 3

Temporary
Transient

Question 4

What is the default value of DATA_RETENTION_TIME_IN_DAYS

Answer 4

1

Question 5

The account setting, MIN_DATA_RETENTION_IN_DAYS does not apply to what objects

Answer 5

Transient
Temporary
External Tables
Materialized Views
Streams

Question 6

What happens with a table’s retention period is decreased from 20 to 1 day

Answer 6

Data from 2 to 20 days is moved to Fail-safe mode

Question 7

How can you show dropped objects

Answer 7

With the HISTORY keyword. Example:
SHOW TABLES HISTORY IN SAMPLE_DB.SAMPLE_SCHEMA

Question 8

How are storage fees calculated for time travel

Answer 8

Calculated for each 24 hour period once data is changed.

Question 9

Which one takes precendence DATA_RETENTION_IN_DAYS and MIN_DATA_RETENTION_TIME_IN_DAYS

Answer 9

the higher value

Question 10

When Time Travel is enabled at the Database, Schema,, and table level, what wins?

Answer 10

Table, then schema, then database

Question 11

A company has a table that has corrupted data, named Data. The company wants to recover the data as it was 5 minutes ago using cloning and Time Travel. What is the SQL

Answer 11

CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);