Summer Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 8w52ceb345

Which methods can be used to delete staged files from a Snowflake stage?

Snowflake SnowPro-Core Full Course Access
Snowflake SnowPro-Core View All Questions

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

A.

Use the DROP 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

command.

D.

Use the REMOVE command after the load completes.

E.

Use the DELETE LOAD HISTORY command after the load completes.

 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

SnowPro-Core PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now SnowPro-Core pdf
Get 60% Discount on All Products, Use Coupon: "8w52ceb345"
Next
What is the following SQL command used for?
What is the maximum Time Travel retention period for a temporary Snowflake table?
Previous