The Stage type that cannot be altered or dropped is 'User and Table Stages'.

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

The Stage type that cannot be altered or dropped is 'User and Table Stages'.

Explanation:
In Snowflake, some stages are system-managed and cannot be altered or dropped using standard DDL. The User Stage is a per-user internal stage created automatically for that user, and its properties aren’t changeable or droppable. Similarly, the Table Stage is an internal stage tied to a specific table (referenced as @%table_name) and is used to load data into or unload data from that table; it isn’t something you can alter or drop independently. These stages exist to support per-user and per-table data operations, and they’re managed alongside the user or table they belong to. Because of this management model, the statement that the stage type cannot be altered or dropped is true.

In Snowflake, some stages are system-managed and cannot be altered or dropped using standard DDL. The User Stage is a per-user internal stage created automatically for that user, and its properties aren’t changeable or droppable. Similarly, the Table Stage is an internal stage tied to a specific table (referenced as @%table_name) and is used to load data into or unload data from that table; it isn’t something you can alter or drop independently. These stages exist to support per-user and per-table data operations, and they’re managed alongside the user or table they belong to. Because of this management model, the statement that the stage type cannot be altered or dropped is true.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy