Snowflake
SOL-C01 · Question #125
A data engineer is tasked with loading JSON data containing nested arrays into Snowflake. Some JSON files exceed Snowflake's maximum single row size limit. Which of the following strategies is the MOS
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #125. The question stem and answer options stay visible for context.
Data Loading and Unloading
Question
A data engineer is tasked with loading JSON data containing nested arrays into Snowflake. Some JSON files exceed Snowflake's maximum single row size limit. Which of the following strategies is the MOST effective way to handle this situation while maintaining data integrity and query performance?
Options
- AIncrease the MAX FILE SIZE parameter in the Snowflake stage configuration to accommodate
- BPre-process the JSON files to split large arrays into multiple smaller JSON documents before
- CUse the `STRIP OIJTER ARRAY file format option during the COPY INTO command to flatten the
- DLoad the entire JSON file as a single VARIANT column and then use Snowflake's JSON parsing
- EImplement a custom IJDF (User-Defined Function) in JavaScript to recursively parse the JSON
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Nested JSON arrays#COPY INTO#Row size limits#Data preprocessing