Which object types are protected by Fail-safe? (Choose two.)
Which object types are protected by Fail-safe? (Choose two.)
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.
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
TABLE & MV
Of course PERMANENT TABLE
I think permanent and materlized view
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.
Permanent Tables and Materialized views
A and D are correct
Correct