Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 1009

What are potential impacts of storing non-native values like dates and timestamps in a VARIANT column in Snowflake?

    Correct Answer: B

    Storing non-native values such as dates and timestamps in a VARIANT column in Snowflake can lead to slower query performance and increased storage consumption. This is because these values, when stored as VARIANT, are often converted to string format. As a result, operations on these values may not be as efficient as they would be if the data were stored in a native date or timestamp data type, leading to slower performance. Additionally, storing these non-native values as strings can require more storage space compared to their native formats.

Discussion
nexerSnowOption: B

Non-native values such as dates and timestamps are stored as strings when loaded into a VARIANT column, so operations on these values could be slower and also consume more space than when stored in a relational column with the corresponding data type.

GwoOption: B

B is correct. https://docs.snowflake.com/en/user-guide/table-considerations

tidzOption: B

https://docs.snowflake.com/en/sql-reference/data-types-semistructured