Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
A.
Use the DROP < file > command after the load completes.
B.
Specify the TEMPORARY option when creating the file format.
C.
Specify the PURGE copy option in the COPY INTO < table > command.
D.
Use the REMOVE command after the load completes.
E.
Use the DELETE LOAD HISTORY command after the load completes.
The Answer Is:
C, D
This question includes an explanation.
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 stage12.
References = DROP STAGE, REMOVE
COF-C03 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"