
Answer-first summary for fast verification
Answer: Permanent table
The question asks which Snowflake table type provides a 7-day Fail-safe period. According to Snowflake documentation, Permanent tables have a Fail-safe period of 7 days, which provides additional data protection beyond Time Travel. Temporary tables have no Fail-safe period, Transient tables have no Fail-safe period, and External tables do not support Fail-safe as they reference data stored outside Snowflake. The community discussion shows 100% consensus on answer C with upvoted comments confirming this is correct.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.