Which stage type can be altered and dropped?

Which stage type can be altered and dropped?
A . Database stage
B . External stage
C . Table stage
D . User stage

View Answer

Answer: B

Explanation:

External stages can be altered and dropped in Snowflake. An external stage points to an external location, such as an S3 bucket, where data files are stored. Users can modify the stage’s definition or drop it entirely if it’s no longer needed. This is in contrast to table stages, which are tied to specific tables and cannot be altered or dropped independently.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Stages1