Once the time-travel period has expired, it is possible to request Snowflake support to retrieve historical data for a period of

A)  Day
B)  Days
C)  It is user-configurable
D)  It depends on the Snowflake edition

Correct Answer :   Days


Explanation :

After the time travel data retention period is over, you can use Snowflake’s fail-safe feature to recover your data. The duration of the fail-safe period is 7 days (Answer B is correct). This is a fixed duration and cannot be changed.

Only Snowflake support personnel can help recover data during the fail-safe period. The fail-safe feature is available to all customers irrespective of the Snowflake edition.

The below diagram succinctly summarizes key differences between Snowflake’s two important data protection features – time-travel and fail-safe.