SnowPro Core Certification — Question 174

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because transient tables in Snowflake only maintain version history for 24 hours, making it impossible to retrieve earlier versions after that period. Options A, C, and D are incorrect as they suggest methods that are not applicable to transient tables beyond the 24-hour limit.