Answer: 7 days

The correct answer is B (7 days) based on Snowflake documentation and the community consensus. Fail-safe is a 7-day period during which Snowflake may be able to recover historical data after the Time Travel retention period has ended, but this is not guaranteed and is intended for disaster recovery purposes only. The community discussion shows strong agreement with B (7 days) with multiple upvoted comments confirming this, while the comment suggesting D (90 days) appears to be confusing fail-safe with Time Travel retention periods, which can be configured up to 90 days but are separate from the fixed 7-day fail-safe period.

Author: LeetQuiz Editorial Team