SnowPro Core Certification — Question 186

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Answer options

• A. Use the DROP [file] command after the load completes.
• B. Specify the TEMPORARY option when creating the file format.
• C. Specify the PURGE copy option in the COPY INTO [table] command.
• D. Use the REMOVE command after the load completes.
• E. Use the DELETE LOAD HISTORY command after the load completes.

Correct answer: C, D

Explanation

The correct answers are C and D because the PURGE option in the COPY INTO command allows for the immediate deletion of files after loading, while the REMOVE command explicitly deletes files from the stage. Options A and E do not directly address file deletion from a stage, and option B relates to file format creation rather than file deletion.