How can a dropped internal stage be restored?

Snowflake does not support Time-Travel, cloning, or UNDROP for internal or external stages. The “DROP STAGE” command permanently removes the stage metadata; once dropped, the only way to regain the stage is to execute a new CREATE STAGE statement (i.e., recreate it). Therefore option D is the sole valid method to “restore” a dropped internal stage.

A. Time Travel applies to tables, schemas, and databases, not to stages; it cannot recover a dropped stage.
B. Zero-copy cloning is unsupported for stages; you cannot clone an object that no longer exists.
C. UNDROP is supported only for tables, schemas, databases, streams, tasks, and tags—not for stages.

1. Snowflake Documentation – “DROP STAGE” Usage Notes, paragraph 3: “After a stage is dropped, it cannot be recovered using UNDROP. To restore the stage, you must re-create it.” (docs.snowflake.com/en/sql-reference/sql/drop-stage)

2. Snowflake Documentation – “UNDROP