Valid COF-C03 Dumps shared by ExamDiscuss.com for Helping Passing COF-C03 Exam! ExamDiscuss.com now offer the newest COF-C03 exam dumps, the ExamDiscuss.com COF-C03 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com COF-C03 dumps with Test Engine here:
Which COPY INTO < table > parameter setting should be used to prevent a partial data load when an error is encountered?
Correct Answer: D
ON_ERROR = ABORT_STATEMENT instructs Snowflake to abort the COPY INTO statement when a data- loading error is encountered. This setting is used when the load should not continue after discovering an invalid record or file. Other ON_ERROR values, such as CONTINUE, can allow valid rows or files to load while problematic records are skipped, which can produce a partial data load. FORCE controls whether files that were previously loaded are loaded again. LOAD_UNCERTAIN_FILES controls how files with uncertain load status are handled. RETURN_FAILED_ONLY controls result reporting and does not determine whether a load is atomic. References: Snowflake SQL Reference - COPY INTO < table > : https://docs.snowflake.com/en/sql-reference/sql/copy- into-table Snowflake Documentation - Handling data-load errors: https://docs.snowflake.com/en/user-guide/data-load- considerations-load ==