
Explanation:
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.
Ultimate access to all questions.
No comments yet.
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.