Which stage type can be altered and dropped?
Which stage type can be altered and dropped?
An external stage can be both altered and dropped. Database, table, and user stages have restrictions that prevent them from being fully alterable or droppable; for example, a table stage is tied to a specific table and is removed when the table is dropped, and user stages are specific to each user and cannot be dropped individually.
The answer is correct as we cannot drop the stage associated with a table or user; only named stages (internal or external) can be dropped.
B. External stage
https://docs.snowflake.com/en/sql-reference/sql/drop-stage Internal and external stages both can be drooped.
internal stages are not alterable or droppable, user stages can be altered and dropped, named stages are droppable but not alterable, and table stages are not directly alterable but are dropped when the associated table is dropped
B is correct
https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage