Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A user created a transient table and has modified it over several days. Three days after its creation, the user wants to restore the table to its original, first version.
How can this be achieved?
A
Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
B
The transient table version cannot be retrieved after 24 hours.
C
Contact Snowflake Support to have the data retrieved from Fail-safe storage.
D
Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
