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

Exam SnowPro Advanced Architect All Questions

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

Exam SnowPro Advanced Architect topic 1 question 98 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect
Question #: 98
Topic #: 1
[All SnowPro Advanced Architect Questions]

When using the COPY INTO [table] command with the CSV file format, how does the MATCH_BY_COLUMN_NAME parameter behave?

  • A. It expects a header to be present in the CSV file, which is matched to a case-sensitive table column name.
  • B. The parameter will be ignored.
  • C. The command will return an error.
  • D. The command will return a warning stating that the file has unmatched columns.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by Atomic_Gecko at March 1, 2024, 11:19 p.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
MSIDDIQUI18
1 month, 1 week ago
Correct Answer: C COPY INTO <table> Command: MATCH_BY_COLUMN_NAME Copy Option Returns Error w when Loading CSV Data
upvoted 1 times
...
MSIDDIQUI18
5 months, 3 weeks ago
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.
upvoted 1 times
...
h8er
8 months, 1 week ago
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
upvoted 2 times
...
Atomic_Gecko
9 months, 3 weeks ago
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
...
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