Snowflake
COF-R02 · Question #212
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. See the full explanation below for the reasoning.
Question
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
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
(38 responses)- A3% (1)
- B13% (5)
- C79% (30)
- E5% (2)
Community Discussion
No community discussion yet for this question.