Databricks Certified Associate Developer for Apache Spark — Question 40

Which of the following operations can perform an outer join on two DataFrames?

Answer options

• A. DataFrame.crossJoin()
• B. Standalone join() function
• C. DataFrame.outerJoin()
• D. DataFrame.join()
• E. DataFrame.merge()

Correct answer: D

Explanation

The correct answer is D, as the DataFrame.join() method can perform outer joins when specified. Options A, C, and E do not directly support outer joins in the same way, and while option B mentions a standalone join function, it lacks the context of DataFrames and is not a valid method for this operation.