Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 13 of 38
Free Preview · 38 of 126 · questions 1–38 of 126 are free. Sign up free to sync your progress across devices.
Hotspot Scenario
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
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;