Snowflake DSA-C02 Exam - Topic 4 Question 34 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 34
Topic #: 4

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?

AHe could not apply Transformation on Stream table data.

Blateral flatten()

CMETADATA$ACTION ()

DTranspose()

Show Suggested 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

by Caren at Nov 14, 2024, 09:42 PM

Limited Time Offer

25%

Off

Get Premium DSA-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Sarah

7 months ago

Transpose() doesn't seem right for JSON data.

upvoted 0 times

...

Gerald

8 months ago

Wait, can you really use METADATA$ACTION for this?

upvoted 0 times

...

Gary

8 months ago

Totally agree, lateral flatten() is essential here!

upvoted 0 times

...

Fidelia

8 months ago

I thought you couldn't transform stream data?

upvoted 0 times

...

Chaya

8 months ago

Lateral flatten() is the way to go for JSON!

upvoted 0 times

...

Carman

8 months ago

Transpose() doesn't seem like the right fit for this scenario. I feel like it’s more about reshaping data rather than transforming JSON.

upvoted 0 times

...

Nohemi

9 months ago

I vaguely recall something about `METADATA$ACTION()`, but I don't think it's used for transforming JSON data specifically.

upvoted 0 times

...

Hillary

9 months ago

I think the `lateral flatten()` function is the right choice for converting JSON into relational columns. It sounds familiar from practice questions.

upvoted 0 times

...

Paulina

9 months ago

I remember studying about transforming JSON data, but I'm not entirely sure which function to use here.

upvoted 0 times

...

Noel

9 months ago

I'm pretty confident I know the right answer here. The "lateral flatten()" function seems like the obvious choice for transforming the JSON data as described in the question.

upvoted 0 times

...

Narcisa

9 months ago

Okay, I've got a strategy - I'll carefully review the SQL function options and think about which one would be best suited for converting JSON data into relational columns.

upvoted 0 times

...

Daisy

9 months ago

Hmm, I'm a bit confused by the mention of "streams" in the context of an ELT process. I'll need to think through how that relates to the data transformation required here.

upvoted 0 times

...

Janessa

9 months ago

This seems like a straightforward question about transforming JSON data into relational columns. I think the key is to identify the appropriate SQL function for this task.

upvoted 0 times

...

Hillary

2 years 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

2 years ago

METADATA$ACTION()? What kind of made-up function is that? Definitely not the solution we need.

upvoted 0 times

...

Jutta

2 years ago

Transpose()? Nah, that's not what we're looking for here. Gotta be lateral flatten() all the way.

upvoted 0 times

Patrick

1 year ago

I'm not sure about METADATA$ACTION (), but I know that Transpose() is not the right function for this task.

upvoted 0 times

...

Glenna

1 year ago

No, lateral flatten() is the best choice for this scenario. It helps in flattening nested JSON data.

upvoted 0 times

...

Shawna

2 years ago

Definitely, lateral flatten() is the perfect choice for this scenario.

upvoted 0 times

...

Ashton

2 years ago

I agree, lateral flatten() is the way to go for transforming JSON data into relational columns.

upvoted 0 times

...

Murray

2 years ago

I think METADATA$ACTION () might also be a good option for data transformation.

upvoted 0 times

...

Laura

2 years ago

I agree, lateral flatten() is the way to go for transforming JSON data into relational columns.

upvoted 0 times

...

Desmond

2 years 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

2 years ago

I agree with Cory, lateral flatten() function is commonly used for this type of transformation.

upvoted 0 times

...

Cory

2 years ago

I think the Data Scientist can use lateral flatten() function for transforming the JSON data into relational columns.

upvoted 0 times

...

Emiko

2 years ago

Hold up, option A? Really? You can't apply transformations on stream data? That's just nonsense!

upvoted 0 times

...

Erinn

2 years 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

2 years ago

I've used lateral flatten() before, it's definitely a good choice for this kind of transformation.

upvoted 0 times

...

Denna

2 years 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

2 years ago

I think METADATA$ACTION () might also work for this transformation.

upvoted 0 times

...

Kirk

2 years ago

I agree, lateral flatten() is the way to go for transforming JSON data.

upvoted 0 times

...