Which option he can choose to remove these files either during data loading or afterwards?

To help manage STAGE storage costs, Data engineer recommended to monitor stage files and re-move them from the stages once the data has been loaded and the files which are no longer needed.

Which option he can choose to remove these files either during data loading or afterwards?
A . He can choose to remove stage files during data loading (using the COPY INTO <table> command).
B . Files no longer needed, can be removed using the PURGE=TRUE command.
C . Files no longer needed, can be removed using the REMOVE command.
D . Script can be used during data loading & post data loading with DELETE command.

View Answer

Answer: A, B

Explanation:

Managing Data Files

Staged files can be deleted from a Snowflake stage (user stage, table stage, or named stage) using the following methods:

・ 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.

・ After the load completes, use the REMOVE command to remove the files in the stage.

Removing files ensures they aren’t inadvertently loaded again. It also improves load performance, because it reduces the number of files that COPY commands must scan to verify whether existing files in a stage were loaded already.