SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 65


Fail-safe is unavailable on which table types? (Choose two.)

Show Answer
Correct Answer: AB

Fail-safe is unavailable on Temporary and Transient tables. Temporary tables are used for storing data temporarily, and they expire at the end of the session in which they were created. Transient tables are designed for data that doesn't need the same level of data protection and durability as permanent tables, thus they do not have a Fail-safe period. Permanent tables, on the other hand, have Fail-safe as part of their data protection strategies. Provisional tables are not a valid type in Snowflake.

Discussion

7 comments
Sign in to comment
moon2351Options: AB
Jan 2, 2022

Transient and temporary tables have no Fail-safe period. As a result, no additional data storage charges are incurred beyond the Time Travel retention period.

DK69Options: AB
May 16, 2022

AB is correct

kjdfsafc87456Options: AB
Aug 24, 2022

Yes, the answer is AB as a permanent table needs high reliability while the first two are temporaries and the C is not the function of snflk.

Tapasgup007Options: AB
Dec 7, 2022

AB are correct

alanhuangjobOptions: AB
Apr 5, 2023

A&B are correct

Mayuri917233Options: AB
May 11, 2023

AB are correct

Mallikharjuna452Options: AB
Jul 18, 2024

A and B are correct