Snowflake Exam COF-R02 Topic 1 Question 21 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 21
Topic #: 1

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

ASTRIP_NULL_VALUES

BSKIP_BYTE_ORDER_MARK

CREPLACE_INVALID_CHARACTERS

DVALIDATION_MODE

Show Suggested Answer

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:

by Georgene at Nov 24, 2023, 07:05 PM

Limited Time Offer

25%

Off

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!