SnowPro Advanced Data Engineer Exam

Exam SnowPro Advanced Data Engineer All QuestionsBrowse all questions from this exam

Question 2

How can the following relational data be transformed into semi-structured data using the LEAST amount of operational overhead?

Use the TO_JSON function.

Use the PARSE_JSON function to produce a VARIANT value.

Use the OBJECT_CONSTRUCT function to return a Snowflake object.

Use the TO_VARIANT function to convert each of the relational columns to VARIANT.

Correct Answer: C

To transform relational data into semi-structured data with the least operational overhead, the OBJECT_CONSTRUCT function in Snowflake is an efficient choice. This function constructs a JSON-like output by taking column names and their corresponding values from a table. This operation is simple and direct, avoiding the need for intermediate steps or conversions, making it the least overhead solution among the options provided.

Discussion

stopthisnowOption: C

Correction, C is the right answer. https://docs.snowflake.com/en/sql-reference/functions/object_construct. select OBJECT_CONSTRUCT(*) from PC_DBT_DB.DBT_ITAHIR.MANUAL_BOOK1

BigDataBBOption: C

https://docs.snowflake.com/en/sql-reference/functions/object_construct.

azure_bimonsterOption: C

C is the right one.

rbeamOption: C

C is correct. sample from Snowflake: SELECT OBJECT_CONSTRUCT(*) AS oc FROM demo_table_1 ORDER BY oc['PROVINCE']; +---------------------------------+ | OC | |---------------------------------| | { | | "CREATED_DATE": "2020-01-19", | | "PROVINCE": "Alberta" | | } | | { | | "CREATED_DATE": "2020-01-18", | | "PROVINCE": "Manitoba" | | } | +---------------------------------+

stopthisnowOption: B

https://docs.snowflake.com/en/sql-reference/functions/object_construct. select OBJECT_CONSTRUCT(*) from PC_DBT_DB.DBT_ITAHIR.MANUAL_BOOK1