SnowPro Core Certification — Question 214

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

Answer options

• A. PURGE
• B. MODIFY
• C. REMOVE
• D. DELETE

Correct answer: C

Explanation

The correct command to delete files from a Snowflake internal stage is the REMOVE command, as it is specifically designed for that purpose. PURGE is used for removing data from a table, MODIFY changes existing data, and DELETE is typically used for deleting rows from tables rather than files in stages.