SnowflakeSnowflake
COF-C02 · Question #147
COF-C02 Question #147: Real Exam Question with Answer & Explanation
Sign in or unlock COF-C02 to reveal the answer and full explanation for question #147. The question stem and answer options stay visible for context.
Storage and Data Protection
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.
Unlock COF-C02 to see the answer
You've previewed enough free COF-C02 questions. Unlock COF-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Time Travel#Transient Tables#Data Retention#Fail-safe