A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.
How can this be achieved?

Question

A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.How can this be achieved?

cesar ganguie · Accepted Answer

Store the data in a table with a variant data type. Query the table.

cesar ganguie · Answer

Flatten the data and store it in structured data types in a flattened table. Query the table.

cesar ganguie · Answer

Store the data in a table with a vai : ant data type and include STRIP_NULL_VALUES while loading the table. Query the table.

cesar ganguie · Answer

Store the data in an external stage and create views on top of it. Query the views.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 355 - SnowPro Core discussion

Suggested answer: B

0 comments