Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 81

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

    Correct Answer: B, D

    VALIDATION_MODE is a parameter of the COPY command in Snowflake, and it is used to validate data to be loaded by the COPY statement without actually completing the load. When VALIDATION_MODE is specified, the command tests the files for errors and returns possible errors without loading any data. Therefore, the correct answers are that VALIDATION_MODE=RETURN_ALL_ERRORS is a parameter of the COPY command, and the VALIDATION_MODE option will validate data to be loaded by the COPY statement without completing the load and will return possible errors.

Discussion
kjdfsafc87456Options: BD

there won't be any data loaded The VALIDATION_MODE copy option instructs a COPY statement to validate the data to be loaded and return results based on the validation option specified. No data is loaded when this copy option is specified.

ThaiyaOptions: BD

B & D

SV1122

Was on exam Dec 31st, 2022

pranaligOptions: BD

correct answer:BD

trainingRalphOptions: BD

The VALIDATION_MODE copy option instructs a COPY statement to validate the data to be loaded and return results based on the validation option specified. No data is loaded when this copy option is specified. For more information about the copy option, see COPY INTO <table>. https://docs.snowflake.com/en/user-guide/data-load-bulk-ts#step-2-validating-the-data-load

SamyakSahooOptions: BD

BD are correct

Ayush24Options: BD

VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them.

Tapasgup007Options: BD

BD are correct

bharathmvOptions: BD

B and D is right

malexandersalazarOptions: BD

BD, the COPY command only tests the files for errors.

Mayuri917233Options: BC

BC are correct

isolated_sniperOptions: BD

B and D are correct. Validating the Data Load The VALIDATION_MODE copy option instructs a COPY statement to validate the data to be loaded and return results based on the validation option specified. No data is loaded when this copy option is specified. For more information about the copy option, see COPY INTO <table>. ref: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts

RajuNaikOptions: BD

BD are correct

nencheppanOptions: BD

BD are correct

PriyeOptions: BD

BD are correct

ajay_1233456Options: BD

BD are correct

baig123Options: BD

B & D are correct answer.