Exam SnowPro Core topic 1 question 182 discussion

Purge in COPY INTO command or REMOVE after that process

CD correct

C and D

CD correct

C and D are correct

A is to delete a stage by using command DROP @mystage;

correct

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

C and D should be correct answer.

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

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.