Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
Use the DROP command after the load completes.
Specify the TEMPORARY option when creating the file format.
Specify the PURGE copy option in the COPY INTO command.
This is a voting comment (?) , you can switch to a simple comment.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
You can sign-up or login (it's free).
Use the REMOVE command after the load completes.
Use the DELETE LOAD HISTORY command after the load completes.
To delete staged files from a Snowflake stage, you can use the PURGE option in the COPY INTO command, which deletes files that were successfully loaded into the table. Additionally, the REMOVE command can be used after the load completes to delete files from a specified stage.
Purge in COPY INTO command or REMOVE after that process
d: https://docs.snowflake.com/en/user-guide/data-load-internal-tutorial-remove-data-files.html c: https://docs.snowflake.com/en/user-guide/data-load-local-file-system-copy.html#:~:text=Staged%20files%20can%20be%20deleted%20from%20a%20Snowflake,command%20to%20remove%20the%20files%20in%20the%20stage.
C and D should be correct answer.
C and D
Files that were loaded successfully can be deleted from the stage during a load by specifying the PURGE copy option in the COPY INTO <table> command. https://docs.snowflake.com/en/user-guide/data-load-local-file-system-copy.html#:~:text=Staged%20files%20can%20be%20deleted%20from%20a%20Snowflake,command%20to%20remove%20the%20files%20in%20the%20stage.
correct
CD correct
C and D are correct
A is to delete a stage by using command DROP @mystage;
PURGE and REMOVE are the correct answer
PURGE and REMOVE
CD correct answer.
CD correct anser for C - https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html