SOL-C01 · Question #192
Consider the following Snowflake SQL code snippet that attempts to load data from a CSV file into a table. Assume the file format 'MY CSV FORMAT' is correctly defined with appropriate delimiters and s
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #192. The question stem and answer options stay visible for context.
Question
Consider the following Snowflake SQL code snippet that attempts to load data from a CSV file into a table. Assume the file format 'MY CSV FORMAT' is correctly defined with appropriate delimiters and skip header settings. Despite setting 'ON ERROR = 'CONTINUE", the COPY INTO operation fails and throws an error. Which of the following scenarios could explain this behavior?
Options
- AThe error is a parsing error related to data type mismatch, and 'ON ERROR = 'CONTINUE" only
- BThe error is related to an integrity constraint violation (e.g., a unique key violation), and =
- CThe file 'data.csv' is not present in the stage @MY_STAGE, and Snowflake cannot find the file to
- DThe user executing the COPY INTO command does not have the 'USAGE' privilege on the stage
- E`ON_ERROR = 'CONTINUE" will always ensure a full load of the file and its impossible to find out
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.