Exam Certified Associate Developer for Apache Spark topic 1 question 175 discussion

Actual exam question from Databricks's Certified Associate Developer for Apache Spark

Question #: 175
Topic #: 1

[All Certified Associate Developer for Apache Spark Questions]

Which of the following code blocks returns a DataFrame containing a column month, an integer representation of the month from column openDate from DataFrame storesDF?

Note that column openDate is of type integer and represents a date in the UNIX epoch format — the number of seconds since midnight on January 1 st, 1970.

A sample of storesDF is displayed below:

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")))

Show Suggested Answer

Suggested Answer: D 🗳️

by Sowwy1 at April 10, 2024, 6:04 p.m.

Comments

Submit Cancel

bp_a_user

2 weeks, 3 days ago

Selected Answer: D

Di is correct The spec says, that the parameter of month requires a target "date/timestamp column to work on".

upvoted 1 times

...

Sowwy1

3 months, 4 weeks ago

D. (storesDF.withColumn("openTimestamp", col("openDate").cast("Timestamp")) .withColumn("month", month(col("openTimestamp"))))

upvoted 1 times

...

Exam Certified Associate Developer for Apache Spark All Questions

View all questions & answers for the Certified Associate Developer for Apache Spark exam

Exam Certified Associate Developer for Apache Spark topic 1 question 175 discussion

Comments

bp_a_user

Sowwy1

SY0-701