Process Semi-Structured Data DEA-C02 Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   How does Snowflake typically handle Avro data files when loading them into a table?

   • AAvro files must be converted to JSON before loading.
   • BAvro files are only supported in external tables, not regular tables.
   • CAvro files are stored as VARIANT columns, and you can query them using semi-structured functions.
   • DAvro files are automatically flattened into relational columns during COPY INTO.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which Snowflake file format type is used to load ORC files?

   • ATYPE = 'PARQUET'
   • BTYPE = 'JSON'
   • CTYPE = 'ORC'
   • DTYPE = 'AVRO'
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which file format type should you specify in a COPY INTO command to load Avro files?

   • ATYPE = 'PARQUET'
   • BTYPE = 'AVRO'
   • CTYPE = 'JSON'
   • DTYPE = 'XML'
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which Snowflake function is used to extract a value from a JSON object by specifying a path expression?

   • AJSON_VALUE
   • BPARSE_JSON
   • CGET_PATH
   • DJSON_EXTRACT
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which Snowflake function is used to parse an XML string into a VARIANT value?

   • AXMLGET
   • BPARSE_XML
   • CPARSE_JSON
   • DTO_XML
   Reveal Solution Discussion Select an answer first