COF-C03: SnowPro Core Certification

Question

Which value types cause queries to run more slowly and storage usage to increase when they are stored in a VARIANT column?

Choose two

Explanation

Retained JSON null values in a VARIANT column waste storage and slow query processing. Timestamps represented as strings are non-native JSON values, so they are stored as strings in VARIANT; operations on them can be slower and consume more space than using the corresponding relational timestamp type.

Learn more

COF-C03: SnowPro Core Certification

AstroTutor

Notes

Readiness

QuestionQ12

Community Discussion