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

Stephanie

6 months ago

I don't think so, STRIP_NULL_VALUES is more about removing null values, not verifying data files.

upvoted 0 times

...

Skye

7 months ago

But what about A) STRIP_NULL_VALUES? Couldn't that also be used to verify data files?

upvoted 0 times

...

Genevive

7 months ago

I agree with VALIDATION_MODE makes sense because it verifies data files before loading them.

upvoted 0 times

...

Stephanie

7 months ago

I think the correct parameter is D) VALIDATION_MODE.

upvoted 0 times

...

Benton

8 months 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

8 months 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

8 months 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

8 months 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

Selene

7 months ago

User 2

upvoted 0 times

...

Bette

7 months ago

User 1

upvoted 0 times

...

Golda

8 months 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

8 months 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

...