Question 21 A data engineer has ingested a JSON file into a table `raw_table` with the following schema: ``` transaction_id STRING, payload ARRAY<customer_id:STRING, date:TIMESTAMP, store_id:STRING> ``` The data engineer wants to efficiently extract the date of each transaction into a table with the following schema: ``` transaction_id STRING, date TIMESTAMP ``` Which of the following commands should the data engineer run to complete this task? | Databricks Certified Data Engineer - Associate Quiz

Question 21

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

transaction_id STRING,
payload ARRAY<customer_id:STRING, date:TIMESTAMP, store_id:STRING>

The data engineer wants to efficiently extract the date of each transaction into a table with the following schema:

transaction_id STRING,
date TIMESTAMP

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

Real Exam

Community

LLeetQuiz

Databricks Certified Data Engineer - Associate