ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 423 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 423
Topic #: 1
[All SnowPro Core Questions]

Which of the following commands are valid options for the VALIDATION_MODE parameter within the Snowflake COPY_INTO command? (Choose two.)

  • A. TRUE
  • B. RETURN_ERROR_SUM
  • C. RETURN_ALL_ERRORS
  • D. RETURN_[N]_ROWS
  • E. RETURN_FIRST__ERRORS
Show Suggested Answer Hide Answer
Suggested Answer: CD 🗳️
by SnowProCertDec22 at Dec. 23, 2022, 12:24 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
SV1122
Highly Voted 1 year, 4 months ago
Selected Answer: CD
VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
upvoted 7 times
BigDataBB
1 year, 3 months ago
Then there is an error on the question RETURN__ROWS is not a valid answer, shoud be like: RETURN_n_ROWS (e.g. RETURN_10_ROWS)
upvoted 3 times
ryotan
8 months, 3 weeks ago
RETURN__ROWS includes two "_" "_", I believe there's a hidden "n" in between. :)
upvoted 2 times
...
...
...
PrasantSadangi
Most Recent 4 weeks ago
Selected Answer: CD
[ VALIDATION_MODE = RETURN_<n>_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS ]
upvoted 1 times
...
Hopefan
11 months, 3 weeks ago
CD there is no RETURN_ERROR_SUM
upvoted 1 times
...
mike24061992
1 year ago
Selected Answer: BC
B. RETURN_ERROR_SUM C. RETURN_ALL_ERRORS Here is a brief explanation of these options: RETURN_ERROR_SUM: This option provides a summary of all validation errors encountered during the data load. It will not load any data into the table. RETURN_ALL_ERRORS: This option returns details of all validation errors encountered during the data load. It will not load any data into the table.
upvoted 1 times
...
OTE
1 year, 2 months ago
I believe this question is incorrect. Answer (C) is clear, but RETURN_ROWS (D) is not valid. Options are: VALIDATION_MODE = RETURN_<n>_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
upvoted 1 times
...
SnowProCertDec22
1 year, 4 months ago
Selected Answer: CD
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#optional-parameters
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago