Answer: REMOVE

The REMOVE command is specifically designed to delete files from stages in Snowflake, working with both internal stages (within Snowflake) and external stages (pointing to cloud storage like S3, Azure Blob Storage, or GCS). This is confirmed by the Snowflake documentation and the community discussion where all respondents selected B with 100% consensus. DELETE is used for removing rows from tables, TRUNCATE removes all rows from a table while preserving the table structure, and DROP removes entire database objects like tables or stages themselves, not individual files within stages.

Author: LeetQuiz Editorial Team