SOL-C01 Question #163: Real Exam Question with Answer & Explanation

Question

You are using a named file format called to load data from CSV files into a Snowflake table named `PRODUCTS'. However, you are encountering errors during the data loading process because some CSV files contain rows with more columns than defined in the `PRODUCTS table. You want Snowflake to ignore these extra columns and load the data without errors. Which of the following approaches can achieve this goal?

Options

• AModify the file format object to include the MISMATCH = TRUE' parameter.
• BModify the file format object to include the ` = FALSE parameter.
• CIn the 'COPY INTO statement, specify the 'MATCH BY COLUMN_NAME' parameter to explicitly
• DIn the 'COPY INTO' statement, specify the 'TRUNCATECOLUMNS = TRUE parameter. This
• EThis cannot be achieved directly. Columns number and data types should match exactly

Explanation

Option B is correct. Setting = FALSE in the file format tells Snowflake to ignore extra columns in the CSV files. The default value for this parameter is TRUE, causing an error when the column count does not match. TRUNCATECOLUMNS parameter has nothing to do with the number of columns. It is used to truncate the strings when loading and can cause an error. The MATCH BY_COLIJMN_NAME is used when you have column names defined and they can have a diffent order. The statement in Option E is incorrect

No community discussion yet for this question.