SnowPro Core Certification — Question 976

Which command can be used to delete staged files from a Snowflake stage when the files are no longer needed?

Answer options

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

Correct answer: C

Explanation

The correct command to delete staged files in Snowflake is REMOVE, as it specifically targets files in a stage. DELETE and DROP do not apply to the context of removing files from a stage, while TRUNCATE TABLE is used for removing all rows from a table, not files from a stage.