SnowPro Core Certification — Question 142

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size S is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?

Answer options

• A. Compress the file and load the compressed file.
• B. Split the file into multiple files in the recommended size range (100 MB - 250 MB).
• C. Use a larger-sized warehouse.
• D. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

Correct answer: D

Explanation

The correct answer is D because setting STRIP_OUTER_ARRAY=TRUE allows the parser to handle the JSON data more efficiently, thus avoiding the LOB size limit. Option A is incorrect because compressing the file won't address the LOB size issue. Option B, while useful for other scenarios, is not necessary here as the command modification in D resolves the problem. Option C does not fix the LOB size exceedance issue directly, as it relates to data parsing rather than warehouse size.