Snowflake
ADA-C01 · Question #57
ADA-C01 Question #57: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #57. The question stem and answer options stay visible for context.
Question
A user accidentally truncated the data from a frequently-modified table. The Administrator has reviewed the query history and found the truncate statement which was run on 2021-12-12 15:00 with query ID 8e5d0ca9-005e-44e6-b858-a8f5b37c5726. Which of the following statements would allow the Administrator to create a copy of the table as it was exactly before the truncated statement was executed, so it can be checked for integrity before being inserted into the main table?
Options
- ACREATE TABLE RESTORE_TABLE CLONE CURRENT_TABLE BEFORE (timestamp => '2021-
- BSELECT * FROM CURRENT_TABLE before (statement => '8e5d0ca9-005e-44e6-b858-
- CINSERT INTO CURRENT_TABLE SELECT * FROM CURRENT_TABLE before (statement =>
- DCREATE TABLE RESTORE_TABLE CLONE CURRENT_TABLE before (statement =>
Unlock ADA-C01 to see the answer
You've previewed enough free ADA-C01 questions. Unlock ADA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.