Which stage type can be altered and dropped?

The correct answer is B. External stage. Only named stages (external and internal named stages) can be altered and dropped in Snowflake. External stages are named objects stored in the Snowflake catalog and support CREATE STAGE, ALTER STAGE, and DROP STAGE commands. Table stages (@%table_name) and user stages (@~) are…

Data Loading and Unloading

Question

Options

ADatabase stage
BExternal stage
CTable stage
DUser stage

How the community answered

(33 responses)

A
6% (2)
B
91% (30)
D
3% (1)

Explanation

Only named stages (external and internal named stages) can be altered and dropped in Snowflake. External stages are named objects stored in the Snowflake catalog and support CREATE STAGE, ALTER STAGE, and DROP STAGE commands. Table stages (@%table_name) and user stages (@~) are implicit stages automatically provided by Snowflake - they cannot be altered or dropped because they are tied to the table or user lifecycle, not independently managed. There is no 'database stage' as a distinct stage type in Snowflake.

Topics

#Snowflake stages#External stages#Data loading#DDL

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice