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

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
A . The validation_mode option is used when creating an Internal Stage
B . validation_mode=return_all_errors is a parameter of the copy command
C . The 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
D . The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Answer: B,D

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html

Latest COF-C01 Dumps Valid Version with 162 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments