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-C02 Dumps Valid Version with 254 Q&As

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

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments