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?
Correct Answer: B
Splitting large arrays into multiple smaller JSON documents before loading is the most effective solution. Option A is incorrect because MAX_FILE_SIZE parameter mainly controls the split into smaller chunks for parallel processing, not row size limits. Option C is incorrect because
'STRIP_OUTER ARRAY only works if there is a single outer array and doesn't address the nested structure or size limits within the document. Option D would likely still exceed row size limits. Option E is an overly complex solution compared to pre-processing the files. Pre- processing allows for controlled splitting to avoid exceeding row size limits and maintains efficient querying.