Snowflake Exam COF-R02 Topic 1 Question 27 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 27
Topic #: 1

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

AThe validation_mode option is used when creating an Internal Stage

Bvalidation_mode=return_all_errors is a parameter of the copy command

CThe validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

DThe validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Show Suggested Answer

Suggested Answer: B

by Carma at Mar 18, 2024, 09:16 PM

Limited Time Offer

25%

Off

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Ernestine

1 days ago

I agree with Noe. A and C make sense because validation_mode is used for validating data during the load process.

upvoted 0 times

...

Annice

4 days ago

I think B and D are correct. The validation_mode option is used to return errors without completing the load.

upvoted 0 times

...

Noe

5 days ago

A and C are true. Validation_mode is important for data validation during loading.

upvoted 0 times

...