
Answer-first summary for fast verification
Answer: Restoring data-related objects that have been deleted within the past 90 days
Snowflake Time Travel enables accessing historical data that has been changed or deleted within a defined retention period. Option B is correct because Time Travel specifically allows restoring data-related objects (tables, schemas, databases) that were deleted within the retention period (up to 90 days for standard edition, longer for higher editions). Option A is incorrect because Time Travel doesn't query objects created within a period, but rather historical states of existing objects. Option C is partially related but not the primary purpose - while Time Travel can support point-in-time analysis, this is more of a secondary benefit rather than a core capability. Option D is too broad and inaccurate since Time Travel only covers the retention period, not 'all periods of time'. The community discussion shows 100% consensus on B, with multiple comments confirming it's the correct answer and explaining that Time Travel's primary function is restoring deleted objects and accessing historical data states.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What capabilities does Snowflake Time Travel provide?
A
Querying data-related objects that were created within the past 365 days
B
Restoring data-related objects that have been deleted within the past 90 days
C
Conducting point-in-time analysis for BI reporting
D
Analyzing data usage/manipulation over all periods of time
No comments yet.