Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Given a table named ‘events‘ with a column ‘items‘ that contains an array of values, which SQL query would transform each item of the array into a separate row?
A
SELECT user_id, event_timestamp, event_name, ARRAY(items) AS item FROM events;_
B
SELECT user_id, event_timestamp, event_name, items FROM events;_
C
SELECT user_id, event_timestamp, event_name, UNNEST(items) AS item FROM events;_
D
SELECT user_id, event_timestamp, event_name, explode(items) AS item FROM events;_