SOL-C01 Question #220: Real Exam Question with Answer & Explanation

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.

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

No community discussion yet for this question.