SOL-C01 · Question #213
SOL-C01 Question #213: Real Exam Question with Answer & Explanation
The correct answer is A: Execute UNDROP TABLE SALES DB.CUSTOMER DATA;'. The ` UNDROP TABLE' command is the fastest and most direct way to restore a recently dropped table within the Time Travel retention period. Option B requires finding the query ID and cloning, which is less efficient. Option C is not a valid Snowflake command. Option D relies on a
Question
A data engineer accidentally drops a critical table named 'CUSTOMER DATA in the 'SALES DB' database. They immediately realize the mistake. Which sequence of actions would be the MOST efficient and reliable way to restore the table using Snowflake's Time Travel feature, assuming the standard data retention period applies and the table hasn't been purged?
Options
- AExecute UNDROP TABLE SALES DB.CUSTOMER DATA;'
- BCreate a clone of the table from a point in time before the drop: 'CREATE TABLE AS (SELECT
- CSALES_DB.CUSTOMER_DATA BEFORE(statement followed by renaming and then dropping the
- DExecute `RESTORE TABLE SALES DB.CUSTOMER DATA;'
- ECreate a new table and then copy the data from a backup.
Explanation
The ` UNDROP TABLE' command is the fastest and most direct way to restore a recently dropped table within the Time Travel retention period. Option B requires finding the query ID and cloning, which is less efficient. Option C is not a valid Snowflake command. Option D relies on an external backup which is outside the scope of Time Travel.
Topics
Community Discussion
No community discussion yet for this question.