Answer: 1 day

According to Snowflake documentation and the community discussion consensus (100% agreement on answer B with upvoted comments), transient tables have a maximum Time Travel retention period of 1 day. This differs from permanent tables which can have up to 90 days of Time Travel retention. The 0 days option refers to Fail-safe, not Time Travel, and 7 days and 90 days are retention periods available for permanent tables but not transient tables.

Author: LeetQuiz Editorial Team