SnowPro Core Certification — Question 921

Which command is used to take away staged files from a Snowflake stage after a successful data ingestion?

Answer options

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

Correct answer: C

Explanation

The correct command to remove staged files in Snowflake after data ingestion is REMOVE, as it specifically targets and deletes files from the stage. DELETE and DROP do not serve this purpose in the context of Snowflake stages, and TRUNCATE is used for clearing data from tables, not for managing staged files.