SnowPro Core Certification — Question 451

User A cloned a schema and overwrote a schema that User B was working on. User B no longer has access to their version of the tables. However, this all occurred within the Time Travel retention period defined at the database level.

How should the missing tables be restored?

Answer options

• A. Use an UNDROP TABLE statement.
• B. Use a CREATE TABLE AS SELECT statement
• C. Rename the cloned schema and use an UNDROP SCHEMA statement.
• D. Contact Snowflake Support to retrieve the data from Fail-safe

Correct answer: C

Explanation

The correct answer is C because renaming the cloned schema allows you to perform an UNDROP SCHEMA operation, which restores the entire schema along with its tables within the Time Travel retention period. Options A and B do not address the schema-level recovery needed here, while D is incorrect since Fail-safe is a last resort for data recovery and is not applicable in this situation.