Snowflake Exam COF-R02 Topic 1 Question 48 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 48
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 Lauran at Dec 11, 2024, 06:34 AM

Limited Time Offer

25%

Off

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