Databricks Discussions

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

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

Question #: 137
Topic #: 1

[All Certified Associate Developer for Apache Spark Questions]

The code block shown below should return a new DataFrame where rows in DataFrame storesDF with missing values in every column have been dropped. Choose the response that correctly fills in the numbered blanks within the code block to complete this task.

Code block:

storesDF.__1__.2__(3__ = __4__)

A. 1. na
2.drop
3. how
4."any"
B. 1. na
2.drop
3. subset
4."all"
C. 1. na
2.drop
3.subset
4. "any"
D. 1. na
2.drop
3. how
4. "all"
E. 1. drop
2. na
3. how
4. "all"

Show Suggested Answer

Suggested Answer: D 🗳️

by arull at Jan. 27, 2024, 11:44 a.m.

Comments

Submit Cancel

mineoolee

6 months ago

Selected Answer: D

"every" is key

upvoted 1 times

...

Samir_91

6 months, 2 weeks ago

Selected Answer: D

in every column --->all any of columns --->any

upvoted 1 times

...

Samir_91

6 months, 2 weeks ago

in every column --->all any of columns --->any

upvoted 1 times

...

jtu363

7 months ago

Selected Answer: A

storesDF.na.drop(how="any").show()

upvoted 1 times

...

Sowwy1

8 months, 1 week ago

D. 1. na 2.drop 3. how 4. "all"

upvoted 1 times

...

arull

10 months, 4 weeks ago

Isn't it option B ? Result_df = storesDF.na.drop(subset="all")

upvoted 2 times

...