SOL-C01 · Question #155
SOL-C01 Question #155: Real Exam Question with Answer & Explanation
The correct answer is A: Option A. Option A is the most appropriate. It correctly specifies the S3 bucket and file, CSV file format, skips the header row CSKIP_HEADER = and handles data conversion errors by continuing the load CON_ERROR = 'CONTINUE"). While other options might partially address the requirements, o
Question
You are using the 'COPY INTO' command to load data from an Amazon S3 bucket into a Snowflake table named 'employees'. The data in S3 is in CSV format, compressed with gzip, and contains a header row. You want to skip the header row during the load and handle any data conversion errors by continuing the load operation. Which of the following 'COPY INTO' commands is most appropriate?
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
Explanation
Option A is the most appropriate. It correctly specifies the S3 bucket and file, CSV file format, skips the header row CSKIP_HEADER = and handles data conversion errors by continuing the load CON_ERROR = 'CONTINUE"). While other options might partially address the requirements, option A is complete and adheres to correct syntax. Option B uses 'SKIP_FILE' which would skip the whole file on error. Option C is closer, but adding `ERROR = FALSE is not directly related to handling data conversion errors. option D is incorrect because 'ON_ERROR = CONTINUE is not a valid syntax, it requires to be in single quotes 'ON ERROR = 'CONTINUE". Option E is also good but 'FIELD DELIMITER = is not required here and is not adding value.
Topics
Community Discussion
No community discussion yet for this question.