Which command is used to remove files from either external cloud storage or an internal staged

The correct answer is B. REMOVE. The REMOVE command (also aliased as RM) is the Snowflake-specific SQL command used to delete files from Snowflake stages - both internal stages (managed by Snowflake) and external stages (pointing to S3, Azure Blob, or GCS). DELETE is a DML command for removing rows from…

Data Loading and Unloading

Question

Options

ADELETE
BREMOVE
CTRUNCATE
DDROP

How the community answered

(45 responses)

A
2% (1)
B
93% (42)
D
4% (2)

Explanation

The REMOVE command (also aliased as RM) is the Snowflake-specific SQL command used to delete files from Snowflake stages - both internal stages (managed by Snowflake) and external stages (pointing to S3, Azure Blob, or GCS). DELETE is a DML command for removing rows from tables, not files from stages. TRUNCATE removes all rows from a table. DROP removes database objects like tables or schemas entirely. REMOVE is the correct choice for stage file management.

Topics

#REMOVE command#Staged files#File management#Data unloading

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice