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 156 discussion

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

Which of the following code blocks fails to return the number of rows in DataFrame storesDF for each distinct combination of values in column division and column storeCategory?

  • A. storesDF.groupBy((col("division"), col("storeCategory")]).count()
  • B. storesDF.groupBy("division").groupBy("storeCategory").count()
  • C. storesDF.groupBy(["division", "storeCategory"]).count()
  • D. storesDF.groupBy("division", "storeCategory").count()
  • E. storesDF.groupBy(col("division“), col("storeCategory")).count()
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by YiJiaSu at Feb. 18, 2024, 12:29 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
PushpakKothekar
2 months, 1 week ago
Selected Answer: B
B is correct
upvoted 2 times
...
SaiPavan10
8 months, 2 weeks ago
Selected Answer: B
B is the right choice. I tested with my dataframe option B threw this error AttributeError: 'GroupedData' object has no attribute 'groupBy'
upvoted 2 times
...
YiJiaSu
10 months ago
Selected Answer: D
D is correct !
upvoted 1 times
Ahlo
9 months, 3 weeks ago
it is possible to run in pyspark - storesDF.groupBy("division", "storeCategory").count() Correct answer is B
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