
Explanation:
The question asks how to remove staged files after they have been successfully loaded during a data loading process. Option B (PURGE copy option) is the correct answer because it automatically removes the source files from the internal stage once they are successfully loaded into the target table. This is a built-in Snowflake feature specifically designed for this purpose. Option A (DROP command) is incorrect as it's used to delete database objects like tables or stages, not individual files within a stage. Option C (FORCE = TRUE parameter) is incorrect as it's used to load files regardless of their load status, not to remove staged files. Option D (LOAD_UNCERTAIN_FILES copy option) is incorrect as it deals with loading files with uncertain status, not removing files after loading. The community discussion shows 100% consensus on answer B with multiple users confirming that PURGE is the correct option for this functionality.
Ultimate access to all questions.
No comments yet.
How can staged files be removed after they have been successfully loaded during a data loading process?
A
Use the DROP command.
B
Use the PURGE copy option.
C
Use the FORCE = TRUE parameter.
D
Use the LOAD_UNCERTAIN_FILES copy option.