SnowPro Core Certification — Question 1133

Which command should be used to drop files from an internal or external stage?

Answer options

• A. DELETE
• B. DROP
• C. REMOVE
• D. TRUNCATE

Correct answer: C

Explanation

The correct command to remove files from a stage is REMOVE, as it specifically targets file deletion from stages in Snowflake. DELETE, DROP, and TRUNCATE do not serve the same purpose, as DELETE is for rows in tables, DROP is for removing objects like tables or views, and TRUNCATE is used to quickly delete all rows in a table without logging individual row deletions.