SOL-C01 · Question #116
SOL-C01 Question #116: Real Exam Question with Answer & Explanation
The correct answer is A: Option A. Option A correctly specifies the custom field delimiter (FIELD DELIMITER = and the explicit date format (DATE FORMAT = 'YYYY-MM-DD") to handle the CSV loading and date transformation requirements effectively. Option B uses 'DATE_FORMAT = 'AUTO" , which might not correctly parse t
Question
You are loading data from a CSV file stored in an AWS S3 bucket into a Snowflake table. The CSV file uses a custom delimiter and contains a date field that needs to be explicitly formatted during the load. Which combination of 'COPY INTO* options BEST addresses these requirements? Assume an existing stage named 's3_stage'.
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
Explanation
Option A correctly specifies the custom field delimiter (FIELD DELIMITER = and the explicit date format (DATE FORMAT = 'YYYY-MM-DD") to handle the CSV loading and date transformation requirements effectively. Option B uses 'DATE_FORMAT = 'AUTO" , which might not correctly parse the date if it's not in a standard format. Options C, D and E don't contain 'ON ERROR to ensure that, in case of error the load continues
Topics
Community Discussion
No community discussion yet for this question.