Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Core Certification · Snowflake
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Why Option B is correct: Snowflake enforces a strict maximum row size limit of 16 MB for semi-structured data types (such as VARIANT, OBJECT, or ARRAY). The error Max LOB size (16777216) exceeded means Snowflake attempted to read a single, unbroken JSON structure that was larger than 16 MB. Since the source data is a large 3 GB concatenation of multiple JSON documents, splitting this massive file into standard, smaller files (100 MB to 250 MB) allows Snowflake to correctly separate the distinct documents into manageable rows under the 16 MB limit during data ingestion.
✅ Correct answer: B. Split the file into multiple files in the recommended size range. ❌ D is only valid if your file has one large outer array, which your description (“concatenation of multiple JSON documents”) says it does not.
https://snowflake.discourse.group/t/what-json-format-does-strip_outer_array-support/7771