Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Associate Developer for Apache Spark All Questions

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

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 Hide Answer
Suggested Answer: D 🗳️
by Sowwy1 at April 10, 2024, 6:04 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Sowwy1
7 months, 2 weeks ago
D. (storesDF.withColumn("openTimestamp", col("openDate").cast("Timestamp")) .withColumn("month", month(col("openTimestamp"))))
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel