DP-203 Certification Practice Question #149

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 row for each item in the arrays.
Which transformation method should you use in the mapping data flow?

Accepted Answer

The requirement is to convert nested JSON arrays into a tabular dataset with one row per array item. In mapping data flows, that is exactly what the Flatten transformation does. Both the Microsoft Learn documentation and the community discussion align fully, so D is highly certain.

More DP-203 practice questions