Câu 50: Databricks Certified Associate Developer for Apache Spark

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")

1. A. The key column storeID needs to be wrapped in the col() operation.
2. B. The key column storeID needs to be in a list like ["storeID"].
3. C. The key column storeID needs to be specified in an expression of both DataFrame columns like storesDF.storeId == employeesDF.storeId.
4. D. There is no DataFrame.join() operation – DataFrame.merge() should be used instead.
5. 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. — đáp án hiện tại