What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO command when loading data from a JSON file into a table?

A. It flattens multiple arrays into a single array.

B. It removes the outer array structure and loads separate rows of data

C. It transforms a pivoted table into an array.

D. It tokenizes each data string using the defined delimiters.

SnowflakeSnowflake

COF-C02 · Question #599

COF-C02 Question #599: Real Exam Question with Answer & Explanation

Sign in or unlock COF-C02 to reveal the answer and full explanation for question #599. The question stem and answer options stay visible for context.

Data Loading and Unloading

Question

What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO <table> command when loading data from a JSON file into a table?

Options

AIt flattens multiple arrays into a single array.
BIt removes the outer array structure and loads separate rows of data
CIt transforms a pivoted table into an array.
DIt tokenizes each data string using the defined delimiters.

Unlock COF-C02 to see the answer

You've previewed enough free COF-C02 questions. Unlock COF-C02 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.

Unlock COF-C02 - $49.99 / 30 days Sign in

Topics

#Snowflake#COPY INTO#JSON loading#STRIP_OUTER_ARRAY

Full COF-C02 Practice Browse All COF-C02 Questions