SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 271


Which object types are protected by Fail-safe? (Choose two.)

Show Answer
Correct Answer: AD

Fail-safe is a data protection feature that ensures data can be recovered in the event of failures. Permanent tables are specifically mentioned as being protected by the Fail-safe feature. Materialized views, which are derived from existing tables and stored physically, are also protected by Fail-safe due to their persistent nature. Temporary and transient tables are designed for short-term use and are not protected by Fail-safe. External tables refer to data stored outside of the database and inherently do not fall under the Fail-safe feature's protection.

Discussion

7 comments
Sign in to comment
SV1122
Dec 27, 2022

Snowflake documentation only mentions fail-safe for permanent tables. No mention of materialized views of external tables. Don't know how to pick 2 answers here. https://docs.snowflake.com/en/user-guide/data-failsafe.html

Naveen90Options: AD
Jan 4, 2023

Answers seem to be correct. Temporary and Transient tables are not protected by fail-safe feature. External table is basically a file, so doesn't make sense for fail-safe.

fahfouhi94Options: AD
Feb 4, 2023

I think permanent and materlized view

EmiBOptions: AD
Mar 11, 2023

TABLE & MV

EmiB
Mar 11, 2023

Of course PERMANENT TABLE

MultiCloudIronManOptions: AD
Jul 13, 2023

Correct

_yyuktaOptions: AD
Feb 26, 2024

A and D are correct

Mallikharjuna452Options: AD
Jul 22, 2024

Permanent Tables and Materialized views