Which of the following commands are valid options for the VALIDATION_MODE parameter within the Snowflake COPY_INTO command? (Choose two.)
Which of the following commands are valid options for the VALIDATION_MODE parameter within the Snowflake COPY_INTO command? (Choose two.)
The VALIDATION_MODE parameter within the Snowflake COPY INTO command supports specific valid options that help in diagnosing load errors. The two correct options for this parameter are RETURN_ALL_ERRORS and RETURN_n_ROWS. RETURN_ALL_ERRORS returns details of all validation errors encountered during the data load without loading any data into the table. RETURN_n_ROWS, where n is a number, returns the first n rows that contain errors. Therefore, these are the valid choices.
VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
Then there is an error on the question RETURN__ROWS is not a valid answer, shoud be like: RETURN_n_ROWS (e.g. RETURN_10_ROWS)
RETURN__ROWS includes two "_" "_", I believe there's a hidden "n" in between. :)
CD there is no RETURN_ERROR_SUM
B. RETURN_ERROR_SUM C. RETURN_ALL_ERRORS Here is a brief explanation of these options: RETURN_ERROR_SUM: This option provides a summary of all validation errors encountered during the data load. It will not load any data into the table. RETURN_ALL_ERRORS: This option returns details of all validation errors encountered during the data load. It will not load any data into the table.
I believe this question is incorrect. Answer (C) is clear, but RETURN_ROWS (D) is not valid. Options are: VALIDATION_MODE = RETURN_<n>_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#optional-parameters