SnowPro Core Certification — Question 939

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

Answer options

• A. Faster query performance and increased storage consumption
• B. Slower query performance and increased storage consumption
• C. Faster query performance and decreased storage consumption
• D. Slower query performance and decreased storage consumption

Correct answer: B

Explanation

Storing non-native values like dates and timestamps in a VARIANT column can lead to slower query performance because the system must convert these values into a usable format, which adds overhead. Additionally, this can result in increased storage consumption since VARIANT data types are less efficient compared to native types, which use storage more effectively.