
Explanation:
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.
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.