Câu 97: Databricks Certified Associate Developer for Apache Spark

Which of the following code blocks returns a new DataFrame where column division is the first two characters of column division in DataFrame storesDF?

1. A. storesDF.withColumn(“division”, substr(col(“division”), 0, 2))
2. B. storesDF.withColumn(“division”, susbtr(col(“division”), 1, 2))
3. C. storesDF,withColumn(“division”, col(“division”).substr(0, 3))
4. D. storesDF.withColumn(“division”, col(“division”).substr(0, 2))
5. E. storesDF.withColumn(“division”, col(“division”).substr(l, 2)) — đáp án hiện tại