
Explanation:
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.
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.