ExamTopics Logo
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 75 discussion

Actual exam question from Databricks's Certified Associate Developer for Apache Spark
Question #: 75
Topic #: 1
[All Certified Associate Developer for Apache Spark Questions]

QUESTION NO: 75 -

Which of the following code blocks returns a DataFrame where column divisionDistinct is the approximate number of distinct values in column division from DataFrame storesDF?

  • A. storesDF.withColumn("divisionDistinct", approx_count_distinct(col("division")))
  • B. storesDF.agg(col("division").approx_count_distinct("divisionDistinct"))
  • C. storesDF.agg(approx_count_distinct(col("division")).alias("divisionDistinct"))
  • D. storesDF.withColumn("divisionDistinct", col("division").approx_count_distinct())
  • E. storesDF.agg(col("division").approx_count_distinct().alias("divisionDistinct"))
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Sowwy1 at April 2, 2024, 1:05 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 ago
I think it's C https://spark.apache.org/docs/3.1.2/api/python/reference/api/pyspark.sql.functions.approx_count_distinct.html
upvoted 2 times
...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago