DP-203 · Question #218
You plan to create an Azure Data Factory pipeline that will include a mapping data flow. You have JSON data containing objects that have nested arrays. You need to transform the JSON-formatted data…
The correct answer is B. flatten. Use the flatten transformation to take array values inside hierarchical structures such as JSON and unroll them into individual rows. This process is known as denormalization. https://docs.microsoft.com/en-us/azure/data-factory/data-flow-flatten
Question
You plan to create an Azure Data Factory pipeline that will include a mapping data flow. You have JSON data containing objects that have nested arrays. You need to transform the JSON-formatted data into a tabular dataset. The dataset must have one tow for each item in the arrays. Which transformation method should you use in the mapping data flow?
Options
- Aunpivot
- Bflatten
- Cnew branch
- Dalter row
How the community answered
(28 responses)- A14% (4)
- B75% (21)
- C7% (2)
- D4% (1)
Explanation
Use the flatten transformation to take array values inside hierarchical structures such as JSON and unroll them into individual rows. This process is known as denormalization. https://docs.microsoft.com/en-us/azure/data-factory/data-flow-flatten
Topics
Community Discussion
No community discussion yet for this question.