2025 Semistructured Data

Question 1

What are the three semistructured datatypes

Answer 1

Variant, Object, and Array

Question 2

What datatype does VARIANT hold

Answer 2

any other datatype

Question 3

What datatype does Array or Object hold

Answer 3

VARIANT

Question 4

What is the maximum compressed size for a Variant datatype

Answer 4

16 mB

Question 5

How are date and timestamps stored in a VARIANT column

Answer 5

As strings

Question 6

What does FLATTEN do?

Answer 6

Flattens nested values into separate columns that can be used to filter query results in a WHERE clause

Question 7

How can users query JSON objects

Answer 7

Either with the dot notation or the bracket notation

<C1>:<L11_element>.<L2_>.<L3_element>
<C1>['<L1_element>']['<L2_element>'] ['<L3_element>']
</L3_element></L2_element></L1_element></C1></L3_element></L2_></L11_element></C1>

Question 8

T/F In both JSON query options, the column name is case insensitive

Answer 8

True

Question 9

T/F In both JSON query options, the element name is case insensitive

Answer 9

False

Question 10

Can you use a Variant column in a clustering key?

Answer 10

No but you can specify an expression to extract a value in a clustering key

Question 11

Which param is required on a FLATTEN command

Answer 11

INPUT

Question 12

Can JSON and PARQUET files be loaded into columns in the same table

Answer 12

No

Question 13

What does SYSTEM$EXPLAIN_JSON_TO_TEXT do?

Answer 13

Converts JSON to human-readable text