SnowPro Core Certification — Question 779

A Snowflake user needs to import a JSON file larger than 16 MB.

What file format option could be used?

Answer options

• A. trim_space = true
• B. compression = auto
• C. strip_outer_array = true
• D. strip_outer_array = false

Correct answer: C

Explanation

The correct answer is C, as setting strip_outer_array to true allows the loading of larger JSON files by removing the outer array wrapper. The other options do not specifically address handling file size limitations related to JSON format imports in Snowflake.