Snowpro Core · Free Practice Question Easy
Question 85
If a user wants to create a table in Snowflake without any Fail-safe protection but with the ability for a 1-day Time Travel retention period, which table type should they choose?
-
A
Historical Table
-
B
Permanent Table
-
C
Transient Table
-
D
Temporary Table
Reveal correct answer
Correct answer: C
A.
There is no such type as a "Historical Table" in Snowflake. It is not a valid option.
B.
Permanent tables include both Time Travel and Fail-safe protections. This option would not meet the requirement of avoiding Fail-safe.
C.
This is the correct answer. Transient tables do not support Fail-safe, but they do support Time Travel with a retention period of up to 1 day, providing a balance for users who want minimal data protection without incurring Fail-safe storage costs.
D.
While temporary tables do not have Fail-safe, they are session-bound and are deleted when the session ends. They would not be suitable if a 1-day Time Travel retention is needed.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
