Snowflake
COF-R02 · Question #212
COF-R02 Question #212: Real Exam Question with Answer & Explanation
Sign in or unlock COF-R02 to reveal the answer and full explanation for question #212. The question stem and answer options stay visible for context.
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.
Unlock COF-R02 to see the answer
You've previewed enough free COF-R02 questions. Unlock COF-R02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.