SnowPro Advanced: Architect — Question 16

A company has a table with that has corrupted data, named Data. The company wants to recover the data as it was 5 minutes ago using cloning and Time Travel.
What command will accomplish this?

Answer options

• A. CREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);
• B. CREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);
• C. CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);
• D. CREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);

Correct answer: C

Explanation

The correct answer is C because it uses the syntax for creating a new table that clones the original table at the specified offset. Options A and B use incorrect order and syntax for creating a clone, while option D incorrectly uses the AT(TIME => ...) format, which is not valid in this context.