Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

The correct answer is C. Specify the PURGE copy option in the COPY INTO <table> command. D. Use the REMOVE command after the load completes. To delete staged files from a Snowflake stage, you can specify the PURGE option in the COPY INTO <table> command, which will automatically delete the files after they have been successfully loaded. Additionally, you can use the REMOVE command after the load completes to…

Data Loading and Unloading

Question

Options

AUse the DROP <file> command after the load completes.
BSpecify the TEMPORARY option when creating the file format.
CSpecify the PURGE copy option in the COPY INTO <table> command.
DUse the REMOVE command after the load completes.
EUse the DELETE LOAD HISTORY command after the load completes.

How the community answered

(60 responses)

A
7% (4)
B
3% (2)
C
88% (53)
E
2% (1)

Explanation

To delete staged files from a Snowflake stage, you can specify the PURGE option in the COPY INTO <table> command, which will automatically delete the files after they have been successfully loaded. Additionally, you can use the REMOVE command after the load completes to manually delete the files from the stage.

Topics

#Snowflake Stages#Data Loading#File Management#COPY INTO

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice