Answer-first summary for fast verification
Answer: Specify the PURGE copy option in the COPY INTO [table] command., Use the REMOVE command after the load completes.
The question asks for two methods to delete staged files from a Snowflake stage. Option C (PURGE copy option in COPY INTO command) automatically removes files after successful loading, which is efficient for post-load cleanup. Option D (REMOVE command) explicitly deletes files from a stage using REMOVE @stage_name/path, providing direct control over file removal. These are standard Snowflake methods for managing staged files. Option A (DROP [file] command) is incorrect as DROP is for database objects, not stage files. Option B (TEMPORARY file format) is irrelevant as file formats define data parsing, not file storage. Option E (DELETE LOAD HISTORY) removes metadata about loads but not the actual staged files.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which methods can be used to remove staged files from a Snowflake stage? (Choose two.)
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.
No comments yet.