SnowPro Core Certification — Question 396

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

Answer options

• A. Permanent Tables
• B. Temporary Tables
• C. External Tables
• D. Materialized Views
• E. Transient Tables

Correct answer: A, D

Explanation

Fail-safe protection is specifically designed for Permanent Tables and Materialized Views, ensuring their data is recoverable in case of accidental deletion. Temporary Tables, External Tables, and Transient Tables do not have Fail-safe protection, meaning their data cannot be recovered once deleted.