Which Snowflake objects can be restored using Time Travel? (Select VNO).

The correct answer is C. Databases D. Schemas. Snowflake's Time Travel feature applies to storage objects: Tables, Schemas, and Databases. Of the options given, Databases (C) and Schemas (D) are the correct choices. Roles (A) and Users (B) are account-level security objects, not storage objects, so they are not subject to…

Storage and Data Protection

Question

Options

ARoles
BUsers
CDatabases
DSchemas
EVirtual warehouses

How the community answered

(58 responses)

A
2% (1)
B
2% (1)
C
93% (54)
E
3% (2)

Explanation

Snowflake's Time Travel feature applies to storage objects: Tables, Schemas, and Databases. Of the options given, Databases (C) and Schemas (D) are the correct choices. Roles (A) and Users (B) are account-level security objects, not storage objects, so they are not subject to Time Travel. Virtual Warehouses (E) are compute resources, not data storage objects, and therefore also cannot be restored with Time Travel. Tables are the most commonly time-traveled object, but since Tables are not listed as an option here, Databases and Schemas are the correct answers.

Topics

#Time Travel#Data Restoration#UNDROP#Database#Schema

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice