DP-203 · Question #218
DP-203 Question #218: Real Exam Question with Answer & Explanation
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
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
Community Discussion
No community discussion yet for this question.