Snowflake Exam ADA-C01 Topic 4 Question 39 Discussion

Scenario:

A TRUNCATE command was accidentally run on a frequently modified table.

Query ID and timestamp are known.

Goal: restore a copy of the table as it existed right before the problematic statement, without affecting the current table.

Why Option D is Correct:

sql

CopyEdit

CREATE TABLE RESTORE_TABLE CLONE CURRENT_TABLE

BEFORE (STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

This uses Zero-Copy Cloning + Time Travel.

The BEFORE (STATEMENT => ...) clause restores the exact state of the table before the TRUNCATE ran.

Creating a clone ensures the original table remains untouched for integrity checks before merging data back.

Why Others Are Incorrect:

A . BEFORE (timestamp => '2021-12-12 00:00')

Wrong timestamp: that's 15 hours before the truncate happened. Too early; may lose needed updates.

B . SELECT * FROM CURRENT_TABLE before (statement => ...)

Syntax is invalid: SELECT can't use BEFORE (STATEMENT => ...) directly like this.

C . INSERT INTO CURRENT_TABLE SELECT * FROM CURRENT_TABLE before (statement => ...)

Same syntax issue. Also risky --- directly inserting into the original table without validating the data first.

SnowPro Administrator Reference:

Cloning with Time Travel

Time Travel with Statement ID