Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
When MATCH_BY_COLUMN_NAME is specified, Snowflake expects the first row of the CSV file to contain column headers.
Snowflake then matches these column headers (which are case-sensitive) with the column names in the target table.
The matching is done based on the order and names of the columns in the CSV file header and the target table. If a column in the CSV file header does not match any column in the target table, it may cause an error or a warning, depending on other parameters and settings.
correct answer is C
https://community.snowflake.com/s/article/COPY-INTO-table-Command-MATCH-BY-COLUMN-NAME-Copy-Option-Returns-Error-When-Loading-CSV-Data
Since option A isn't true unless the parameter is set to CASE_SENSITIVE and CSV column name detection is in Open Private Preview only , the correct answer here should be C
upvoted 2 times
...
Log in to ExamTopics
Sign in:
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.
Want to SAVE BIG on Certification Exam Prep?
MSIDDIQUI18
4 days, 12 hours agoh8er
2 months, 3 weeks agoAtomic_Gecko
4 months, 1 week ago