nerdexam
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)
  • A
    14% (5)
  • B
    71% (25)
  • C
    9% (3)
  • E
    6% (2)

Community Discussion

No community discussion yet for this question.

Full ADA-C01 Practice