BlackFriday 2024! 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 28 Discussion

Actual exam question for Snowflake's COF-R02 exam
Question #: 28
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 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
5 months ago
I don't think so, STRIP_NULL_VALUES is more about removing null values, not verifying data files.
upvoted 0 times
...
Skye
6 months ago
But what about A) STRIP_NULL_VALUES? Couldn't that also be used to verify data files?
upvoted 0 times
...
Genevive
6 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
7 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
7 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
7 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
7 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
6 months ago
User 2
upvoted 0 times
...
Bette
6 months ago
User 1
upvoted 0 times
...
...
Golda
7 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
...

Save Cancel