SOL-C01 · Question #112
SOL-C01 Question #112: Real Exam Question with Answer & Explanation
The correct answer is E: DATE INPUT FORMAT = 'AUTO', DATE OUTPUT FORMAT = 'YYYY-MM-DD'. The 'DATE INPUT FORMAT option specifies the format of the dates in the source data, and setting it to 'AUTO' allows Snowflake to automatically detect the format. The option specifies the desired format for dates loaded into the table. 'DATE_FORMAT and 'TIMESTAMP_FORMAT are not va
Question
Consider a scenario where you are loading data from an external stage (AWS S3) into a Snowflake table. The data contains date fields in various formats. You want to ensure that all dates are consistently loaded into Snowflake using the 'YYYY-MM-DD' format. Which of the following COPY INTO options can you use to achieve this?
Options
- ADATE FORMAT = 'YYYY-MM-DD'
- BTIMESTAMP FORMAT = 'YYYY-MM-DD'
- CCONVERT TIMEZONE = FALSE
- DON ERROR = 'SKIP FILE'
- EDATE INPUT FORMAT = 'AUTO', DATE OUTPUT FORMAT = 'YYYY-MM-DD'
Explanation
The 'DATE INPUT FORMAT option specifies the format of the dates in the source data, and setting it to 'AUTO' allows Snowflake to automatically detect the format. The option specifies the desired format for dates loaded into the table. 'DATE_FORMAT and 'TIMESTAMP_FORMAT are not valid COPY INTO options. `CONVERT_TIMEZONE' is related to time zone conversions, and 'ON ERROR handles errors during loading, but neither of them directly address date format
Topics
Community Discussion
No community discussion yet for this question.