Exam DEA-C02 Topic 1 Question 352 Discussion

Actual exam question for Snowflake's DEA-C02 exam
Question #: 352
Topic #: 1

You are loading JSON data into a Snowflake table with a 'VARIANT' column. The JSON data contains nested arrays with varying depths. You need to extract specific values from the nested arrays and load them into separate columns in your Snowflake table. Which approach would provide the BEST performance and flexibility?

A. Use a stored procedure to parse the JSON data and insert values into the table row by row. B. Load the entire JSON into a 'VARIANT column and then use SQL with nested 'FLATTEN' functions to extract the desired values during query time. C. Create a view with nested 'FLATTEN' functions to extract the values from the 'VARIANT column. The view serves as the source for further transformations. D. Use a 'COPY' command with a 'TRANSFORM' clause that uses JavaScript UDFs to parse the JSON and extract the values during the load process. Load the extracted values directly into the target columns. E. Use Snowpipe with auto-ingest, loading directly into the table with the 'VARIANT column. Define data quality checks with pre-load data transformation.

Suggested Answer: D Vote an answer

Using a 'COPY command with a 'TRANSFORM' clause and JavaScript UDFs allows for efficient parsing and extraction of values during the load process. This minimizes the amount of data stored in the 'VARIANT column and avoids expensive query-time parsing. Stored procedures perform row by row operations which are inefficient. Using Flatten functions could be useful to denormalise json, but javascript parsing during load is better. Snowpipe and auto-ingest just move the challenge to a real-time streaming scenario, which may not be optimized for transforming data into a relational structure.

by Zebulon at Aug 02, 2025, 07:32 PM

Limited Time Offer

15%

Off

Get Premium DEA-C02 Questions as Interactive Self Test Engine or PDF

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business