Answer: 1 day

The question asks for the default Time Travel retention period in Snowflake. According to Snowflake documentation and the community discussion consensus (with 100% of answers selecting A and multiple comments confirming this), the default retention period is 1 day. While options B (7 days), C (45 days), and D (90 days) represent possible extended retention periods available in higher editions (with 90 days being the maximum in Enterprise Edition), they are not the default setting. The default of 1 day applies to all Snowflake editions automatically without any configuration required.

Author: LeetQuiz Editorial Team