Snowflake
ADA-C01 · Question #56
What Snowflake capabilities are commonly used in rollback scenarios? (Choose two.)
The correct answer is B. CREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT => D. ALTER TABLE prd_table SWAP WITH prd_table_bkp. See the full explanation below for the reasoning.
Question
What Snowflake capabilities are commonly used in rollback scenarios? (Choose two.)
Options
- ASELECT SYSTEM$CANCEL_QUERY('problematic_query_id');
- BCREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT =>
- CCREATE TABLE prd_table_bkp AS SELECT * FROM
- DALTER TABLE prd_table SWAP WITH prd_table_bkp;
- EContact Snowflake Support to retrieve Fail-safe data.
How the community answered
(35 responses)- A14% (5)
- B71% (25)
- C9% (3)
- E6% (2)
Community Discussion
No community discussion yet for this question.