Câu 40: Databricks Certified Data Analyst Associate

A data engineer is working with a nested array column products in table transactions. They want to expand the table so each unique item in products for each row has its own row where the transaction_id column is duplicated as necessary. They are using the following incomplete command: Which of the following lines of code can they use to fill in the blank in the above code block so that it successfully completes the task?

1. A. array distinct(products)
2. B. explode(products) — đáp án hiện tại
3. C. reduce(products)
4. D. array(products)
5. E. flatten(products)