Answer: 0 days

The correct answer is D (0 days) because transient tables in Snowflake do not have a Fail-safe period. According to Snowflake documentation and the community discussion, transient tables are specifically designed to not include Fail-safe protection, unlike permanent tables which have a 7-day Fail-safe period. The community consensus strongly supports this with multiple comments citing official documentation and upvoted responses confirming that transient tables have no Fail-safe retention period. Option B (7 days) is incorrect as that applies to permanent tables, not transient tables.

Author: LeetQuiz Editorial Team