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?
To restore the missing tables within the Time Travel retention period, the correct approach is to use an UNDROP TABLE statement. Time Travel allows the restoration of dropped tables within the retention period, so this operation will bring back the tables as they existed before they were overwritten.
C is correct! If an object with the same name already exists, UNDROP fails. Need to rename the existing object, which then enables us to restore the previous version of the object.
C is correct
https://docs.snowflake.com/en/sql-reference/sql/undrop-schema
Correct