SnowflakeSnowflake
DEA-C02 · Question #13
DEA-C02 Question #13: Real Exam Question with Answer & Explanation
The correct answer is B: select t2.value:name::varchar AS memberName ,t2.value:registered::timestamp AS registeredDttm ,t2.value:age::number AS age ,t2.value:eyeColor::varchar AS eyeColor from jCustRaw t1 ,lateral flatten (input => v:teamMembers) t2;. https://docs.snowflake.com/user-guide/semistructured-considerations#using-flatten-to-list-distinct-
Data Transformation
Question
The JSON below is stored in a VARIANT column named V in a table named jCustRaw: 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.
Options
- Aselect t2.name AS memberName ,t2.registered AS registeredDttm ,t2.age AS age ,t2.eyeColor AS eyeColor from jCustRaw t1 ,lateral flatten (v) t2;
- Bselect t2.value:name::varchar AS memberName ,t2.value:registered::timestamp AS registeredDttm ,t2.value:age::number AS age ,t2.value:eyeColor::varchar AS eyeColor from jCustRaw t1 ,lateral flatten (input => v:teamMembers) t2;
- Cselect v:teamMembers.name::varchar AS memberName ,v:teamMembers.registered::timestamp AS registeredDttm ,v:teamMembers.age::number AS age ,v:teamMembers.eyeColor::varchar AS eyeColor from jCustRaw;
- Dselect v:teamMembers[0].name::varchar AS memberName ,v:teamMembers[0].registered::timestamp AS registeredDttm ,v:teamMembers[0].age::number AS age ,v:teamMembers[0].eyeColor::varchar AS eyeColor from jCustRaw;
Explanation
https://docs.snowflake.com/user-guide/semistructured-considerations#using-flatten-to-list-distinct-
Topics
#JSON querying#Semi-structured data#LATERAL FLATTEN#Snowflake SQL
Community Discussion
No community discussion yet for this question.