SnowPro Advanced: Architect — Question 66

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

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because the MATCH_BY_COLUMN_NAME parameter ensures that the CSV file's header matches the table's columns in a case-sensitive manner. Option B is incorrect as the parameter does have significance; C is wrong as it doesn't generate an error if matched properly, and D is incorrect because it doesn't issue warnings about unmatched columns if headers are aligned.