Answer: REMOVE

The correct answer is C (REMOVE) because the REMOVE command is specifically designed to delete files from Snowflake stages (internal or external). The community discussion shows 100% consensus on answer C, with multiple comments referencing the official Snowflake documentation for the REMOVE command. Option A (PURGE) is incorrect as it's a copy option used during data loading operations, not a standalone command for deleting staged files. Option B (MODIFY) is not a valid command for file deletion in stages. Option D (DELETE) is incorrect because the DELETE command is used for removing rows from tables, not files from stages.

Author: LeetQuiz Editorial Team