**Question 20** A junior data engineer has ingested a JSON file into a table `raw_table` with the following schema: ``` cart_id STRING, items ARRAY<item_id:STRING> ``` The junior data engineer would like to unnest the `items` column in `raw_table` to result in a new table with the following schema: ``` cart_id STRING, item_id STRING ``` Which of the following commands should the junior data engineer run to complete this task? | Databricks Certified Data Engineer - Associate Quiz

Question 20

A junior data engineer has ingested a JSON file into a table raw_table with the following schema:

cart_id STRING,
items ARRAY<item_id:STRING>

The junior data engineer would like to unnest the items column in raw_table to result in a new table with the following schema:

cart_id STRING,
item_id STRING

Which of the following commands should the junior data engineer run to complete this task?

Real Exam

Community

LLeetQuiz

Databricks Certified Data Engineer - Associate