A company stores product images in an Amazon S3 bucket. They want to use Snowflake to manage and query metadata about these images, but the images themselves will remain in S3. The engineering team needs to reference the images in Snowflake queries. What should they configure?

Create an internal stage and copy all images into Snowflake's storage.

Create a table with a VARIANT column and load the image binary data into it.

Use the S3 bucket directly in queries without creating a stage.

Create an external stage pointing to the S3 bucket and use the stage to reference the image files in queries.

A developer has a string containing JSON: '{"name": "John", "age": 30}'. They need to insert this into a VARIANT column. What is the correct way to do this?

Use OBJECT_CONSTRUCT to build the object from the string.

Use ARRAY_AGG to aggregate the string into an array.

Use PARSE_JSON to convert the string to VARIANT before inserting.

Insert the string directly into the VARIANT column without any conversion.

SnowflakeSnowPro Advanced — Architect

Domain 3Objective 3

Manage Semi-Structured and Unstructured Data ARA-C01 Practice Questions (Page 2)

Part of the Data Engineering domain, which accounts for 24% of the ARA-C01 exam.

18questions here

4free pages

8concepts

24%of the exam

Questions 6–10

6foundation · easy
Which Snowflake function is used to expand an array or object column into multiple rows for querying nested semi-structured data?
Select an answer first
7application · medium
A company stores product images in an Amazon S3 bucket. They want to use Snowflake to manage and query metadata about these images, but the images themselves will remain in S3. The engineering team needs to reference the images in Snowflake queries. What should they configure?
Select an answer first
8foundation · easy
A data engineer needs to store a JSON document that contains an array of objects. Which Snowflake data type is most appropriate for storing this entire JSON document without losing its structure?
Select an answer first
9foundation · easy
When loading XML data into Snowflake, which file format type should be used in the COPY INTO command?
Select an answer first
10application · easy
A developer has a string containing JSON: '{"name": "John", "age": 30}'. They need to insert this into a VARIANT column. What is the correct way to do this?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to ARA-C01

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “ARA-C01” is a trademark of its owner, used for identification only.

Manage Semi-Structured and Unstructured Data ARA-C01 Practice Questions (Page 2)

Questions 6–10

Which Snowflake function is used to expand an array or object column into multiple rows for querying nested semi-structured data?

A company stores product images in an Amazon S3 bucket. They want to use Snowflake to manage and query metadata about these images, but the images themselves will remain in S3. The engineering team needs to reference the images in Snowflake queries. What should they configure?

A data engineer needs to store a JSON document that contains an array of objects. Which Snowflake data type is most appropriate for storing this entire JSON document without losing its structure?

When loading XML data into Snowflake, which file format type should be used in the COPY INTO command?

A developer has a string containing JSON: '{"name": "John", "age": 30}'. They need to insert this into a VARIANT column. What is the correct way to do this?

Keep studying — Data Engineering