What happens when an external or an internal stage is dropped? (Choose two.)
What happens when an external or an internal stage is dropped? (Choose two.)
When an external stage is dropped, only the stage itself is removed, but the files stored within the external location are not affected. This means, the external file storage maintains the files as they are without deletion. Conversely, when an internal stage is dropped, both the stage and all of its files are permanently deleted and cannot be recovered. This deletion is final and ensures that no additional storage costs are incurred for those files.
For an internal stage, all of the files in the stage are purged from Snowflake, regardless of their load status. This prevents the files from continuing to using storage and, consequently, accruing storage charges. However, this also means that the staged files cannot be recovered after a stage is dropped. For an external stage, only the stage itself is dropped; any data files in the referenced external location (Amazon S3, Google Cloud Storage, or Microsoft Azure) are not removed. https://docs.snowflake.com/en/sql-reference/sql/drop-stage.html#drop-stage
per the docs explain
per the docs explain
https://docs.snowflake.com/en/sql-reference/sql/drop-stage.html#drop-stage
AD are correct
correct
correct