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 Practice Questions with 156 Q&As

Updated Study Material | Instant Download | Detailed Answers and Explanations

Subscribe
Notify of
guest
0 Comments