Discuss Snowflake SOL-C01 Exam Topic 3 Question 8

Which of the following are examples of semi-structured data formats? (Choose any 3 options)

AJSON

BCSV

CParquet

DXML

Suggested Answer: A, C, D

Semi-structured data refers to formats that do not follow a rigid relational schema but still contain structural tags or hierarchies, allowing flexible representation of nested or irregular data. In Snowflake,JSON,Parquet, andXMLare all considered semi-structured because they incorporate metadata, hierarchical fields, or tagged data that can vary across records. JSON offers key--value pairs and nested arrays, making it ideal for logs and API responses. Parquet, being a columnar file format containing both schema definitions and metadata, is optimized for analytics while still supporting semi-structured capabilities such as variable field nesting. XML uses tags and attributes to represent hierarchical content, making it semi-structured as well. On the other hand, CSV represents strictly structured, row/column-based data without inherent metadata or hierarchy, so it is not considered semi-structured. Snowflake treats semi-structured formats by loading them into the VARIANT data type, enabling powerful SQL-based exploration using path notation.

=======================================

Get Premium SOL-C01 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

12 comments · newest first

Verlene 3 months ago

I chose A, D, and B. CSV can be semi-structured with headers.

Alease 3 months ago

I agree, A, C, and D! CSV feels too rigid for semi-structured.

Doretha 3 months ago

I think A, C, and D are semi-structured. JSON and XML are flexible.

Judy 3 months ago

Totally agree, JSON and XML are the go-tos for semi-structured data!

Jenelle 3 months ago

Wait, Parquet? Isn’t that more structured?

Glory 4 months ago

XML is another classic example!

Lino 5 months ago

I thought CSV was just plain text, not semi-structured.

Soledad 5 months ago

JSON is definitely semi-structured!

Dorcas 6 months ago

I’m pretty confident about JSON and XML, but I’m torn between Parquet and CSV for the third option.

Sheldon 6 months ago

I feel like CSV is more of a flat file format, so I wouldn't pick that one.

Lorrie 6 months ago

I remember practicing a question like this, and I think Parquet is more structured than semi-structured.

Antonio 7 months ago

I think JSON and XML are definitely semi-structured, but I'm not sure about CSV.

Snowflake SOL-C01 Exam - Topic 3 Question 8 Discussion