SnowPro Core Certification — Question 34

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

Answer options

• A. Temporary
• B. Transient
• C. Provisional
• D. Permanent

Correct answer: A, B

Explanation

Fail-safe is not applicable to Temporary and Transient tables because these types are designed for short-term data storage and do not retain data after session termination or failure events. In contrast, Provisional and Permanent tables are intended for long-term data retention and thus support fail-safe mechanisms.