Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 378

What file formats does Snowflake support for loading semi-structured data? (Choose three.)

    Correct Answer: B, D, E

    Snowflake supports loading semi-structured data from multiple formats. Among the options provided, JSON, Avro, and Parquet are commonly accepted formats for semi-structured data in Snowflake. TSV and PDF are not typically used for this type of data. Therefore, the correct choices for loading semi-structured data into Snowflake are JSON, Avro, and Parquet.

Discussion
SV1122Options: BDE

Snowflake can import semi-structured data from JSON, Avro, ORC, Parquet, and XML formats and store it in Snowflake data types designed specifically to support semi-structured data. And it stores in Array, Object, and Variant formats https://docs.snowflake.com/en/user-guide/semistructured-intro.html#:~:text=Snowflake%20can%20import%20semi%2Dstructured,to%20support%20semi%2Dstructured%20data.

MultiCloudIronManOptions: BDE

correct

fahfouhi94Options: BDE

BDE is correct

KeshavaMugulurOptions: DE

DDE is right

KeshavaMugulur

Sorry for typo, it is B D E