New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam DSA-C02 Topic 4 Question 34 Discussion

Actual exam question for Snowflake's DSA-C02 exam
Question #: 34
Topic #: 4
[All DSA-C02 Questions]

Data Scientist used streams in ELT (extract, load, transform) processes where new data inserted in-to a staging table is tracked by a stream. A set of SQL statements transform and insert the stream contents into a set of production tables. Raw data is coming in the JSON format, but for analysis he needs to transform it into relational columns in the production tables. which of the following Data transformation SQL function he can used to achieve the same?

Show Suggested Answer Hide Answer
Suggested Answer: B

To know about lateral flatten SQL Function, please refer:

https://docs.snowflake.com/en/sql-reference/constructs/join-lateral#example-of-using-lateral-with-flatten


Contribute your Thoughts:

Hillary
5 days ago
I'm with Erinn on this one. Lateral flatten() is the way to go. Though I gotta say, these options are a bit of a mixed bag, aren't they?
upvoted 0 times
...
Chaya
10 days ago
METADATA$ACTION()? What kind of made-up function is that? Definitely not the solution we need.
upvoted 0 times
...
Jutta
11 days ago
Transpose()? Nah, that's not what we're looking for here. Gotta be lateral flatten() all the way.
upvoted 0 times
Laura
2 days ago
I agree, lateral flatten() is the way to go for transforming JSON data into relational columns.
upvoted 0 times
...
...
Desmond
15 days ago
I'm not sure about lateral flatten(), but I think METADATA$ACTION () could also be used for transforming the data.
upvoted 0 times
...
James
17 days ago
I agree with Cory, lateral flatten() function is commonly used for this type of transformation.
upvoted 0 times
...
Cory
30 days ago
I think the Data Scientist can use lateral flatten() function for transforming the JSON data into relational columns.
upvoted 0 times
...
Emiko
1 months ago
Hold up, option A? Really? You can't apply transformations on stream data? That's just nonsense!
upvoted 0 times
...
Erinn
1 months ago
Hmm, I'd go with option B. Lateral flatten() seems like the perfect SQL function to transform that JSON data into relational columns.
upvoted 0 times
Melvin
6 days ago
I've used lateral flatten() before, it's definitely a good choice for this kind of transformation.
upvoted 0 times
...
Denna
13 days ago
I'm not sure about Transpose(), but I don't think we can't apply Transformation on Stream table data.
upvoted 0 times
...
Gretchen
27 days ago
I think METADATA$ACTION () might also work for this transformation.
upvoted 0 times
...
Kirk
30 days ago
I agree, lateral flatten() is the way to go for transforming JSON data.
upvoted 0 times
...
...

Save Cancel