SnowPro Core Certification — Question 977

How can a dropped internal stage be restored?

Answer options

• A. Enable Time Travel.
• B. Clone the dropped stage.
• C. Execute the UNDROP command.
• D. Recreate the dropped stage.

Correct answer: D

Explanation

The correct answer is D, as recreating the dropped stage is the only way to restore it after deletion. Option A, enabling Time Travel, does not apply to stages since it is for recovering data in tables. Option B, cloning, is not possible for a stage that has been dropped, and option C, executing the UNDROP command, is not a valid command for stages.