Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Free Preparation Discussions
MENU
Snowflake Exam COF-R02 Topic 1 Question 23 Discussion
Actual exam question for
Snowflake's
COF-R02 exam
Question #: 23
Topic #: 1
[All COF-R02 Questions]
Topic #: 1
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
Suggested Answer:
D
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE=RETURN_n_ROWS|RETURN_ERRORS|RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data filesinsteadof loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:
Currently there are no comments in this discussion, be the first to comment!