# SnowPro-Advanced-Data-Engineer — Question 606

**Type:** multiple_choice
**Topics:** topic_1

## Question

The JSON below is stored in a VARIANT column named V in a table named jCustRaw:
//IMG//

Which query will return one row per team member (stored in the teamMembers array) along with all of the attributes of each team member?

## Correct Answer

_See scenario._

## Explanation

Selected Answer: B
Technically, none of the statements work properly. The nearest valid option is B.

create or replace table persons as
select parse_json(
'{
 "_id": "4534554654640",
 "company": "Boo",
 "name": "Dean",
 "teamMembers": [
 {
 "age":29,
 "eyeColor": "green"
 },
 {
 "age":39,
 "eyeColor": "green2"
 }
 ]
}'
) as c ;

select f.value:eyeColor::varchar as eyeColor, 
f.value:age 
from TASK_DB.PUBLIC.PERSONS as p,
lateral flatten(input => p:teamMembers) f;

**Reference:** examtopics_top_comment

---
Source: https://hiexam.net/q/snowflake/SnowPro-Advanced-Data-Engineer/606  
Practice (tracked): https://hiexam.net/study/SnowPro-Advanced-Data-Engineer/practice