Answer: Use the PURGE copy option.

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.

Author: LeetQuiz Editorial Team