nerdexam
Snowflake

COF-R02 · Question #50

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

The correct answer is B. validation_mode=return_all_errors is a parameter of the copy command D. The validation_mode option will validate data to be loaded by the copy statement without. See the full explanation below for the reasoning.

Question

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

Options

  • 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
  • DThe validation_mode option will validate data to be loaded by the copy statement without

How the community answered

(28 responses)
  • A
    11% (3)
  • B
    71% (20)
  • C
    18% (5)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice