The correct answer is D. ON_ERROR = ABORT_STATEMENT .
ON_ERROR = ABORT_STATEMENT stops the load operation if an error is encountered. This helps avoid loading only part of a dataset when a file or row error occurs.
Why D is correct:
If the goal is to avoid a partial dataset, the load should fail rather than continue after errors.
ABORT_STATEMENT prevents Snowflake from loading only the valid rows while skipping invalid ones.
Why the other options are incorrect:
A). FORCE = FALSE prevents reloading files that were already loaded, but it does not prevent partial loads caused by data errors.
B). RETURN_FAILED_ONLY affects command output reporting. It does not control whether partial data is loaded.
C). LOAD_UNCERTAIN_FILES = FALSE controls loading files with uncertain load status, but it is not the primary parameter for avoiding partial datasets caused by load errors.
D). ON_ERROR = ABORT_STATEMENT is the correct parameter because it stops the load when an error occurs.
Official Snowflake documentation reference:
Snowflake documentation for COPY INTO < table > describes ON_ERROR = ABORT_STATEMENT as the option that aborts the load operation when an error is encountered.
Reference: Snowflake Documentation - COPY INTO < table > ; Snowflake Documentation - ON_ERROR copy option; SnowPro Core Study Guide - Data Loading and Unloading.