New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake Exam COF-R02 Topic 1 Question 48 Discussion

Actual exam question for Snowflake's COF-R02 exam
Question #: 48
Topic #: 1
[All COF-R02 Questions]

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

Show Suggested Answer Hide 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

Contribute your Thoughts:

Submit Cancel
Kenia
11 days ago
I'm not sure, but I think A) STRIP_NULL_VALUES could also be used for data verification.
upvoted 0 times
...
Tarra
11 days ago
Hmm, I think the correct answer is 'VALIDATION_MODE'. It makes sense to have an option to verify the data files before loading them into the table.
upvoted 0 times
Bernardine
5 days ago
I agree, 'VALIDATION_MODE' seems like the right choice.
upvoted 0 times
...
...
Eileen
17 days ago
I agree with Yong, VALIDATION_MODE makes sense for verifying data files.
upvoted 0 times
...
Yong
20 days ago
I think the answer is D) VALIDATION_MODE.
upvoted 0 times
...

Save Cancel