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

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

Question #: 78
Topic #: 1

[All Certified Associate Developer for Apache Spark Questions]

Which of the following code blocks returns a DataFrame sorted alphabetically based on column division?

A. storesDF.sort("division")
B. storesDF.orderBy(desc("division"))
C. storesDF.orderBy(col("division").desc())
D. storesDF.orderBy("division", ascending - true)
E. storesDF.sort(desc("division"))

Show Suggested Answer

Suggested Answer: A 🗳️

by zozoshanky at July 30, 2023, 8:20 p.m.

Comments

Submit Cancel

58470e1

8 months, 3 weeks ago

Selected Answer: A

Cannot be D...ascending - true syntax is incorrect. if the optional ascending parameter is supplied, it should be ascending = True...False for descending. By Default, sort method is ascending...so it's A

upvoted 1 times

...

arturffsi

1 year, 5 months ago

Option D works as well

upvoted 2 times

gaco

11 months, 2 weeks ago

no. Only A. D would work if it was "ascending = True". "ascending = true" is not a valid statement.

upvoted 2 times

...

carlosmps

1 year, 1 month ago

i think so, both works :s

upvoted 1 times

...

azure_bimonster

1 year, 6 months ago

Selected Answer: A

A is good one here

upvoted 1 times

...

thanab

1 year, 11 months ago

A https://spark.apache.org/docs/3.1.2/api/python/reference/api/pyspark.sql.DataFrame.orderBy.html#pyspark.sql.DataFrame.orderBy

upvoted 2 times

...

cookiemonster42

2 years ago

Selected Answer: A

it's A, checked in databricks

upvoted 1 times

...

zozoshanky

2 years ago

C is correct

upvoted 1 times

cookiemonster42

2 years ago

we need ascending, not descending, mate

upvoted 3 times

...