Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Question 335

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the STRIP_OUTER_ARRAY file format option.

What does the STRIP_OUTER_ARRAY file format do?

It removes the last element of the outer array.

It removes the outer array structure and loads the records into separate table rows.

It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns.

It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records.

Correct Answer: B

Enabling the STRIP_OUTER_ARRAY file format option in Snowflake removes the outer array structure of a JSON document and loads the elements within that array as separate rows in the table. This allows each record in the JSON array to be processed individually, facilitating easier handling and manipulation of the data within Snowflake.

Discussion

AS314

https://cloudyard.in/2021/05/snowflake-strip_outer_array-in-json/

SV1122Option: B

STRIP_OUTER_ARRAY, Removes the outer set of square brackets [ ] when loading the data, separating the initial array into multiple lines

KnightVictorOption: B

STRIP Removes OUTER outer set of square brackets ARRAY []

_yyuktaOption: B

B. It removes the outer array structure and loads the records into separate table rows.

MultiCloudIronManOption: B

correct