SOL-C01 · Question #220
You are managing a Snowflake environment with continuous data protection enabled. A critical table, `CUSTOMER ORDERS , was accidentally dropped by a user. You need to restore this table with the least
The correct answer is A. Restore the table using Time Travel with the UNDROP TABLE command.. The 'UNDROP TABLE command using Time Travel is the quickest and most efficient way to restore a dropped table. Time Travel allows you to restore data to a specific point in time within a defined period (up to 90 days for Enterprise Edition). Fail-safe is not directly accessible f
Question
You are managing a Snowflake environment with continuous data protection enabled. A critical table, `CUSTOMER ORDERS , was accidentally dropped by a user. You need to restore this table with the least possible data loss and downtime. Which of the following steps should you take?
Options
- ARestore the table using Time Travel with the UNDROP TABLE command.
- BRestore the table using Fail-safe.
- CCreate a clone of the database containing the table from a point in time before the table was
- DRestore the table from a backup stored in cloud storage.
- EWait for the Fail-safe period to expire and then restore the table.
How the community answered
(23 responses)- A83% (19)
- B4% (1)
- C4% (1)
- D9% (2)
Explanation
The 'UNDROP TABLE command using Time Travel is the quickest and most efficient way to restore a dropped table. Time Travel allows you to restore data to a specific point in time within a defined period (up to 90 days for Enterprise Edition). Fail-safe is not directly accessible for data restoration and serves as a last resort for Snowflake. Option C is possible but may involve restoring a larger scope than necessary. Option D necessitates a proper backup and restore procedure which would require additional setup. Option E is incorrect as fail-safe can not directly
Topics
Community Discussion
No community discussion yet for this question.