Exam SnowPro Core topic 1 question 835 discussion

Actual exam question from Snowflake's SnowPro Core

Question #: 835
Topic #: 1

What are reasons for using the VALIDATE function in Snowflake after a COPY INTO command execution? (Choose two.)

A. To validate the files that have been loaded earlier using the COPY INTO command
B. To fix errors that were made during the execution of the COPY INTO command
C. To return errors encountered during the execution of the COPY INTO command
D. To identify potential issues in the COPY INTO command before it is executed
E. To count the number of errors encountered during the execution of the COPY INTO command

Show Suggested Answer

Suggested Answer: AC 🗳️

by Heetec at Oct. 10, 2023, 9:12 p.m.

Submit Cancel

Highly Voted 8 months, 2 weeks ago

Selected Answer: AC

AC correct - https://docs.snowflake.com/en/sql-reference/functions/validate

upvoted 6 times

8 months, 1 week ago

and https://docs.snowflake.com/en/sql-reference/sql/copy-into-table

upvoted 1 times

...

2 months, 2 weeks ago

Thanks, easy to confuse this with VALIDATION_MODE option for COPY INTO. This question is about VALIDATE after the COPY INTO

upvoted 3 times

...

Most Recent 1 week, 1 day ago

Selected Answer: CE

I am not sure what validating the files in option A means. When it returns the errors, we can also count the number of errors.

upvoted 1 times

...