Databricks Certified Data Analyst Associate Exam - Topic 1 Question 60 Discussion

Question

A Data Analyst is working on sensor_df; this DataFrame contains two columns: record_datetime timestamp and record array.

Which code fragment returns a DataFrame that splits the record column into separate columns and has one array item per row?

Nelida · Accepted Answer

C) exploded_df = sensor_df.withColumn('record_exploded', explode('record'))
exploded_df = exploded_df.select(
'record_datetime',
'record_exploded.sensor_id',
'record_exploded.status',
'record_exploded.health'
)

Nelida · Answer

A) Uses withColumn, but selects sensor_id, status, and health as if they are already top-level columns.

Nelida · Answer

B) Selects nested fields before correctly creating the exploded column.

Nelida · Answer

D) exploded_df = exploded_df.select('record_datetime', 'record_exploded')