Snowflake
COF-R02 · Question #205
COF-R02 Question #205: Real Exam Question with Answer & Explanation
Sign in or unlock COF-R02 to reveal the answer and full explanation for question #205. The question stem and answer options stay visible for context.
Question
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 small 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?
Options
- ACompress the file and load the compressed file.
- BSplit the file into multiple files in the recommended size range (100 MB -250 MB).
- CUse a larger-sized warehouse.
- DSet STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
Unlock COF-R02 to see the answer
You've previewed enough free COF-R02 questions. Unlock COF-R02 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.