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?
- A.
- B.
- C.
- D.
snowflake · SnowPro-Advanced-Data-Engineer · Q606 · multiple_choice · topic_1
The JSON below is stored in a VARIANT column named V in a table named jCustRaw: //IMG// Which query will return one ro…
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
Practice with progress tracking
Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.