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

Question

A junior data analyst accidentally dropped a schema named 'STAGING' in the 'RAW DATA' database. They need to recover the schema and its contents as quickly as possible. Which of the following approaches would be the MOST efficient and reliable way to achieve this, assuming Time Travel is enabled for the account and the retention period is sufficient?

Options

• AUse the `UNDROP SCHEMA STAGING;' command within the 'RAW DATA' database context.
• BCreate a new schema named 'STAGING' and manually restore the tables and views from a
• CRestore the entire 'RAW DATA' database to a point in time before the schema was dropped using
• DCreate a clone of the database at a point in time before the schema was dropped, then rename the
• EUse the `RECOVER DATABASE RAW DATA;' command to recover the entire database.

Explanation

UNDROP SCHEMA' is the most efficient and reliable way to recover a dropped schema, assuming Time Travel is enabled. It restores the schema to its previous state without affecting other parts of the database. Option B requires manual effort and is prone to errors. Options C, D and E are overkill as they restore or clone the entire database which takes more time and resources. 'RECOVER DATABASE is not a valid command in Snowflake.

No community discussion yet for this question.