Answer-first summary for fast verification
Answer: When dropping an external stage, the files are not removed and only the stage is dropped., When dropping an internal stage, the files are deleted with the stage and the files are not recoverable.
The correct answers are A and D based on Snowflake documentation and the community consensus. Option A is correct because when dropping an external stage, only the stage metadata is removed from Snowflake; the actual files in the external cloud storage (S3, GCS, or Azure) remain untouched. Option D is correct because when dropping an internal stage, all files stored within Snowflake are permanently deleted and cannot be recovered, as internal stages store data directly in Snowflake's managed storage. Option B is incorrect because external stage files are not removed. Option C is incorrect because internal stage files are not recoverable after drop. Option E is incorrect because all files in an internal stage are deleted, not just selected ones.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When an external or internal stage is dropped, which two of the following statements are true?
A
When dropping an external stage, the files are not removed and only the stage is dropped.
B
When dropping an external stage, both the stage and the files within the stage are removed.
C
When dropping an internal stage, the files are deleted with the stage and the files are recoverable.
D
When dropping an internal stage, the files are deleted with the stage and the files are not recoverable.
E
When dropping an internal stage, only selected files are deleted with the stage and are not recoverable.
No comments yet.