Answer: Time Travel

The question asks for a Snowflake feature that enables both querying historical data and restoring data. Time Travel (option B) is the correct answer because it allows users to query data as it existed at any point within the retention period (up to 90 days for standard tables) and also restore dropped tables, schemas, or databases to a previous state. The community discussion strongly supports this with 100% consensus on answer B, multiple upvoted comments confirming Time Travel's dual capabilities, and references to Snowflake documentation. Other options are incorrect: Cluster keys (A) optimize query performance but don't handle historical data querying or restoration; Fail-safe (C) provides disaster recovery for 7 days after Time Travel retention ends but doesn't support querying; Cloning (D) creates copies of objects but doesn't inherently enable querying historical versions or restoring from past states.

Author: LeetQuiz Editorial Team