Snowflake
COF-R02 · Question #253
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the…
The correct answer is B. The transient table version cannot be retrieved after 24 hours. See the full explanation below for the reasoning.
Question
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table. How can this be accomplished?
Options
- AUse Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
- BThe transient table version cannot be retrieved after 24 hours.
- CContact Snowflake Support to have the data retrieved from Fail-safe storage.
- DUse the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
How the community answered
(25 responses)- A8% (2)
- B72% (18)
- C4% (1)
- D16% (4)
Community Discussion
No community discussion yet for this question.