SnowPro Advanced Architect Exam

Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam

Question 44

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?

CREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);

CREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);

CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);

CREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);

Correct Answer: C

To recover the data in the table as it was 5 minutes ago using cloning and Time Travel, the correct SQL command is 'CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);'. This command creates a new table named Recover_Data as a clone of the Data table, using the data state from 5 minutes prior (calculated as 60 seconds times 5 minutes). The syntax 'CREATE TABLE Recover_Data CLONE Data' accurately reflects this process in SQL.

Discussion

hillcat111Option: C

Answer is C and is validated

callipso21Option: C

https://docs.snowflake.com/en/user-guide/data-time-travel Section - Cloning Historical Objects