Free DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Web TestEngine Demo

Q12 Single choice

The code block shown below contains an error. The code block intended to return a new DataFrame that is the result of an inner join between DataFrame storesDF and DataFrame employeesDF on column storeId. Identify the error.

Code block:
storesDF.join(employeesDF, "inner", "storeId")

A
The key column storeID needs to be wrapped in the col() operation.
B
The key column storeID needs to be in a list like ["storeID"].
C
The key column storeID needs to be specified in an expression of both DataFrame columns like storesDF.storeId == employeesDF.storeId.
D
There is no DataFrame.join() operation - DataFrame.merge() should be used instead.
E
The column key is the second parameter to join() and the type of join in the third parameter to join() - the second and third arguments should be switched.

DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Web TestEngine demo