Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How can optimal query performance be achieved when processing a JSON file containing numerous dates and arrays in Snowflake?
A
Flatten the data and store it in structured data types in a flattened table. Query the table.
B
Store the data in a table with a VARIANT data type. Query the table.
C
Store the data in a table with a VARIANT data type and include STRIP_NULL_VALUES while loading the table. Query the table.
D
Store the data in an external stage and create views on top of it. Query the views.
