DP-203 Certification Practice Question #40

Question

You use PySpark in Azure Databricks to parse the following JSON input.

You need to output the data in the following tabular format.

How should you complete the PySpark code? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the spit bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Accepted Answer

The target output requires one row per dog per person, so the JSON must be flattened in two stages: first explode the top-level `persons` array into one row per person, then project the nested `name` and `age` fields, and finally explode the nested dog field to create one row per dog. That is exactly how PySpark?s `explode` and nested column access work. The comments agree on the structure even though there is some noise about alias wording and a possible singular/plural typo in the drag-drop prompt.

More DP-203 practice questions