Removing files from a stage after you are done loading the files improves performance when subsequently loading data

Removing files from a stage after you are done loading the files improves performance when subsequently loading data
A . TRUE
B. FALSE

Answer: A

Explanation:

Managing Unloaded Data Files

Staged files can be deleted from a Snowflake stage using the REMOVE command to remove the files in the stage after you are finished with them.

Removing files improves performance when loading data, because it reduces the number of files that the COPY INTO <table> command must scan to verify whether existing files in a stage were loaded already.

Latest ARA-C01 Dumps Valid Version with 156 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments