COF-C02 · Question #147
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 A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days. To go back to the first version of a transient table created three days prior, one can use Time Travel if the DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days. This allows the user to access historical data within the specified retention period.
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
(41 responses)- A88% (36)
- B7% (3)
- C2% (1)
- D2% (1)
Explanation
To go back to the first version of a transient table created three days prior, one can use Time Travel if the DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days. This allows the user to access historical data within the specified retention period.
Topics
Community Discussion
No community discussion yet for this question.