Free DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Web TestEngine Demo

Q59 Single choice

Which of the following code blocks returns a DataFrame where column managerName from DataFrame storesDF is split at the space character into column managerFirstName and column managerLastName?

A sample of DataFrame storesDF is displayed below:

A
(storesDF.withColumn("managerFirstName", split(col("managerName"), " ")[0])
.withColumn("managerLastName", split(col("managerName"), " ")[1]))
B
(storesDF.withColumn("managerFirstName", col("managerName"). split(" ")[1])
.withColumn("managerLastName", col("managerName").split(" ")[2]))
C
(storesDF.withColumn("managerFirstName", split(col("managerName"), " ")[1])
.withColumn("managerLastName", split(col("managerName"), " ")[2]))
D
(storesDF.withColumn("managerFirstName", col("managerName").split(" ")[0])
.withColumn("managerLastName", col("managerName").split(" ")[1]))
E
(storesDF.withColumn("managerFirstName", split("managerName"), " ")[0])
.withColumn("managerLastName", split("managerName"), " ")[1]))

DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Web TestEngine demo