nerdexam
Snowflake

COF-C02 · Question #329

How can a dropped internal stage be restored?

The correct answer is D. Recreate the dropped stage. Once an internal stage is dropped in Snowflake, it cannot be recovered or restored using Time Travel or UNDROP commands. The only option is to recreate the dropped stage.

Storage and Data Protection

Question

How can a dropped internal stage be restored?

Options

  • AEnable Time Travel.
  • BClone the dropped stage.
  • CExecute the UNDROP command.
  • DRecreate the dropped stage.

How the community answered

(30 responses)
  • A
    3% (1)
  • C
    7% (2)
  • D
    90% (27)

Explanation

Once an internal stage is dropped in Snowflake, it cannot be recovered or restored using Time Travel or UNDROP commands. The only option is to recreate the dropped stage.

Topics

#Internal stages#Object management#Dropped objects#UNDROP command limitations

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice