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

Suggested Answer: B 🗳️

by YiJiaSu at Feb. 18, 2024, 12:29 p.m.

Comments

Submit Cancel

PushpakKothekar

3 weeks, 3 days ago

Selected Answer: B

B is correct

upvoted 1 times

...

SaiPavan10

7 months 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

8 months, 2 weeks ago

Selected Answer: D

D is correct !

upvoted 1 times

Ahlo

8 months, 1 week ago

it is possible to run in pyspark - storesDF.groupBy("division", "storeCategory").count() Correct answer is B