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, C

Explanation:

Let’s evaluate each option:

A. He can choose to remove stage files during data loading (using the COPY INTO <table> command).

Correct. Using the AUTO_DELETE=TRUE option with the COPY INTO command will remove the files from the stage once they’ve been successfully loaded.

B. Files no longer needed, can be removed using the PURGE=TRUE command.

Incorrect. In Snowflake, there isn’t a PURGE=TRUE command.

C. Files no longer needed, can be removed using the REMOVE command.

Correct. The REMOVE command can be used on a stage to remove specific files or patterns of files that are no longer needed.

D. Script can be used during data loading & post data loading with DELETE command.

Incorrect. In Snowflake, you don’t use the DELETE command to remove files from stages. You’d use the REMOVE command.

Based on the above evaluation, the correct options are:

A and C.