Snowflake Exam COF-R02 Topic 1 Question 28 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 28
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 Leonida at Apr 14, 2024, 08:58 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Benton

9 days ago

Don't worry, Lisha. If we all agree on VALIDATION_MODE, it's probably the right answer. Unless, of course, one of us is secretly a data warehouse saboteur trying to trick the rest of us. *laughs*

upvoted 0 times

...

Lisha

11 days ago

I'm with you all on VALIDATION_MODE. Although, I have to admit, I'm a little nervous about this question. What if there's a trick we're all missing?

upvoted 0 times

...

Eden

12 days ago

Yeah, I'm leaning towards VALIDATION_MODE as well. It's the only option that explicitly mentions verifying the data, which is what the question is asking about.

upvoted 0 times

...

Ettie

13 days ago

I agree with Golda. VALIDATION_MODE seems like the most logical choice. The other options are more about handling data issues during the load process, not verifying the files before the load.

upvoted 0 times

...

Golda

15 days ago

Hmm, I think VALIDATION_MODE is the correct answer here. It makes sense that this parameter would be used to instruct the COPY command to verify the data files instead of just loading them into the table.

upvoted 0 times

...

Alecia

16 days ago

This is a tricky question. I'm not entirely sure which parameter to use to verify data files instead of loading them. VALIDATION_MODE sounds like it might be the right option, but I'm not 100% confident.

upvoted 0 times

...