SnowPro Core Certification — Question 762

A user has enabled the STRIP_OUTER_ARRAY file format option for the COPY INTO {table} command to remove the outer array structure.

What else will this format option and command do?

Answer options

• A. Load the records into separate table rows.
• B. Unload the records from separate table rows.
• C. Export data files in smaller chunks.
• D. Ensure each unique element stores values of a single native data type.

Correct answer: A

Explanation

The STRIP_OUTER_ARRAY option effectively removes the outer array layer, allowing the individual records to be loaded directly into separate rows of the table. The other options do not accurately describe the functionality of this command; unloading and exporting data or ensuring data types are not relevant to the operation of loading records into rows.