Answer: 1 day

According to Snowflake documentation and the community consensus (100% agreement with upvoted comments), temporary tables in Snowflake have a maximum Time Travel retention period of 1 day. This is shorter than permanent tables which can have up to 90 days of Time Travel. The community discussion shows unanimous support for option B, with multiple users confirming that temporary tables have a 0-1 day Time Travel window. Options A (90 days), C (7 days), and D (45 days) are incorrect as they represent retention periods for other table types or configurations, not temporary tables specifically.

Author: LeetQuiz Editorial Team