You can pass structured ARRAYs, structured OBJECTs, and MAPs to the FLATTEN function.
https://docs.snowflake.com/en/sql-reference/data-types-structured#label-structured-types-working-flatten
FLATTEN can be used to convert semi-structured data to a relational representation.
https://docs.snowflake.com/en/sql-reference/functions/flatten
So the answer is C. Both of the above
Correct answer
FLATTEN is used to unnest semi-structured data. Don't see an application for structured data as by definition it shouldn't be nested.
upvoted 3 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MohamedBen
3 weeks, 4 days agoDataEngineerNeeraj1
2 months, 2 weeks agoaemilka
3 months, 2 weeks agoomiiUST
4 months, 3 weeks agoMallikharjuna452
5 months, 1 week ago372110c
6 months agoMBrat
7 months, 1 week agoMultiCloudIronMan
1 year, 5 months agoMayuri917233
1 year, 7 months agoTapasgup007
2 years agolhstudylh
2 years, 9 months ago