SnowPro Associate Platform SOL-C01

By Snowflake · Question Mode

QuestionQ75

Load and leverage structured, semi-structured, and unstructured data

Which practices are recommended for loading semi-structured data into a Snowflake table?

Choose two
Explanation

Snowflake supports storing hierarchical semi-structured data in a VARIANT column and loading staged semi-structured files into the target table with COPY INTO. This preserves Snowflake’s native semi-structured representation while using its standard bulk-loading mechanism.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!