SnowPro Core Recertification — Question 24

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 in a VARIANT column can lead to slower query performance because the data needs to be cast or converted during query execution. Additionally, such storage can result in increased storage consumption due to the overhead associated with managing these non-native types, making option B the correct choice, while the others provide misleading outcomes.