How does Snowflake support the use of structured and semi-structured data? (Select TWO)
A.
Structured data is supported through the use of traditional relational database tables, organized into rows and columns.
B.
Structured and semi-structured data are stored in separate physical storage locations; users must choose which type of data to use when creating a table.
C.
Semi-structured data is supported through the use of automatically indexed database tables.
D.
All semi-structured data is automatically converted into structured data when it is loaded into Snowflake.
E.
Users can load and query semi-structured data using SQL using the SQL semi-structured data handling functions.
Snowflake supports structured data in standard tables and semi-structured data in VARIANT, OBJECT, and ARRAY columns.
Users can load and query both using standard SQL functions, without schema constraints for semi-structured formats.
[Reference:, Snowflake Docs: Semi-Structured Data Overview, ===========]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit