SnowPro Core Certification — Question 1095

How can staged files be removed during data loading once the files have loaded successfully?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer, B, indicates the PURGE copy option specifically designed to remove staged files post successful loading. Option A, the DROP command, is used for dropping entire tables or objects rather than handling staged files. Option C, the FORCE = TRUE parameter, does not relate to removing staged files, but rather forces certain operations. Option D, the LOAD_UNCERTAIN_FILES copy option, is meant for handling files that are uncertain and does not address file removal.