Exam4Training

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

Exit mobile version