Snowflake SnowPro Advanced: Data Scientist Certification Exam DSA-C02 Question # 10 Topic 2 Discussion

Snowflake SnowPro Advanced: Data Scientist Certification Exam DSA-C02 Question # 10 Topic 2 Discussion

DSA-C02 Exam Topic 2 Question 10 Discussion:
Question #: 10
Topic #: 2

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?


A.

He could not apply Transformation on Stream table data.


B.

lateral flatten()


C.

METADATA$ACTION ()


D.

Transpose()


Get Premium DSA-C02 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.