Snowflake didn't provide explicit information about the impact of dropping the transient table, but I have found this: https://hevodata.com/learn/what-is-snowflake-transient-table/.
"For instance, if a system failure occurs and a Transitory Table is dropped or lost, the data is no longer accessible by you or Snowflake after one day. As a result, it’s advisable to use Snowflake Transient Table only for data that does not require failure protection or can be recreated outside of Snowflake."
Hence, after max 1 day, the data will be lost.
Time Travel for Temporary and Transient tables is 0 or 1. Hence, even if the tables itself is no longer available for being used, it is possible to use it for 1 more day, if the Time Travel was set to 1. Hence, I vote C.
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
37ceea2
3 weeks, 1 day ago37ceea2
3 weeks, 3 days ago