nerdexam
Microsoft

DP-203 · Question #293

You are creating an Apache Spark job in Azure Databricks that will ingest JSON-formatted data. You need to convert a nested JSON string into a DataFrame that will contain multiple rows. Which Spark…

The correct answer is A. explode. https://learn.microsoft.com/en-us/azure/databricks/kb/scala/flatten-nested-columns-dynamically

Submitted by sofia.br· Mar 30, 2026Develop data processing

Question

You are creating an Apache Spark job in Azure Databricks that will ingest JSON-formatted data. You need to convert a nested JSON string into a DataFrame that will contain multiple rows. Which Spark SQL function should you use?

Options

  • Aexplode
  • Bfilter
  • Ccoalesce
  • Dextract

How the community answered

(46 responses)
  • A
    78% (36)
  • B
    2% (1)
  • C
    7% (3)
  • D
    13% (6)

Explanation

https://learn.microsoft.com/en-us/azure/databricks/kb/scala/flatten-nested-columns-dynamically

Topics

#explode function#nested JSON#Apache Spark SQL#Azure Databricks

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice