Databricks Certified Associate Developer for Apache Spark
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Which of the following code blocks correctly returns a DataFrame with a month column containing the integer month value extracted from the openDate column in storesDF?
Note: The openDate column is of integer type and stores UNIX epoch timestamps (seconds since midnight January 1, 1970).
A sample of storesDF is shown below:
storeId openDate
0 1100746394
1 1474410343
2 1116610009
3 1180035265
4 1408024997
storeId openDate
0 1100746394
1 1474410343
2 1116610009
3 1180035265
4 1408024997
A
storesDF.withColumn("month", getMonth(col("openDate")))
B
storesDF.withColumn("month", substr(col("openDate"), 4, 2))
C
(storesDF.withColumn("openDateFormat", col("openDate").cast("Date")) .withColumn("month", month(col("openDateFormat"))))
D
(storesDF.withColumn("openTimestamp", col("openDate").cast("Timestamp")) .withColumn("month", month(col("openTimestamp"))))
E
storesDF.withColumn("month", month(col("openDate")))