SnowPro Core Certification — Question 1069

Which table type has a Fail-safe period of 7 days?

Answer options

• A. Temporary table
• B. Transient table
• C. Permanent table
• D. External table

Correct answer: C

Explanation

The correct answer is C, as Permanent tables are designed to maintain data integrity and include a Fail-safe period of 7 days for recovery. Temporary and Transient tables do not have this feature, and External tables are typically used for data stored outside the database, lacking the Fail-safe period entirely.