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

Question

You are tasked with loading data from a Parquet file into a Snowflake table. The Parquet file contains a column with a timestamp datatype. However, the timestamp values are being incorrectly loaded into Snowflake due to a mismatch in the expected timestamp format. Which approach should you take to address this issue?

Options

• AModify the Parquet file to align with the default Snowflake timestamp format.
• BUse the 'TIMESTAMP_FORMAT option within the 'COPY INTO' command with the appropriate
• CCreate a view on top of the Parquet file and apply a 'TO_TIMESTAMP' function with the correct
• DSet the 'TIME ZONE parameter at the session level before running the 'COPY INTO* command.
• EUpdate the Snowflake table column datatype to TEXT and then CAST the values.

Explanation

Option B is the most direct and efficient way to handle timestamp format discrepancies. By specifying the 'TIMESTAMP_FORMAT option within the 'COPY INTO' command, you can instruct Snowflake to parse the timestamp values in the Parquet file using the correct format string. Option A is less practical as modifying the Parquet file might not always be feasible. Option C is also incorrect because Parquet files cannot be created on views. Option D addresses time zone issues, not format discrepancies. Option E will load them as text, which is not desirable.

No community discussion yet for this question.