Certified Associate Developer for Apache Spark Exam QuestionsBrowse all questions from this exam

Certified Associate Developer for Apache Spark Exam - Question 90


The code block shown below should return a new DataFrame that is the result of an outer join between DataFrame storesDF and DataFrame employeesDF on column storeId. 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__)

Show Answer
Correct Answer: CE

To perform an outer join between two DataFrames in a code block as described, the correct method is `join`. The `join` method requires the other DataFrame to join with as the second argument, the type of join (in this case, 'outer') as the third argument, and the condition for joining (matching storeId columns) as the fourth argument. Therefore, the complete and correct fill-ins for the code block are `join`, `employeesDF`, `outer`, and `storesDF.storeId === employeesDF.storeId`.

Discussion

1 comment
Sign in to comment
cookiemonster42Option: A
Aug 2, 2023

Correct