SnowPro Core Certification — Question 299

What happens when an external or an internal stage is dropped? (Choose two.)

Answer options

• 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.

Correct answer: A, D

Explanation

The correct answer is A and D. When an external stage is dropped, the files remain, so A is correct. For an internal stage, the files are deleted along with the stage and cannot be recovered, which makes D the right choice. Options B, C, and E are incorrect as they misrepresent the behavior of dropping stages.