Certified Associate Developer for Apache Spark Exam

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

Question 89

The code block shown below should return a new DataFrame that is the result of an inner join between DataFrame storeDF and DataFrame employeesDF on column storeId. Choose the response chat correctly fills in the numbered blanks within the code block to complete this task.

Code block:

storesDF.__1__(__2__, __3__, __4__)

1. join

2. employeesDF

3. "inner"

4. storesDF.storeId === employeesDF.storeId

1. join

2. employeesDF

3. "storeId"

4. "inner"

1. merge

2. employeesDF

3. "storeId"

4. "inner"

1. join

2. employeesDF

3. "inner"

4. "storeId"

1. join

2. employeesDF

3. "inner"

4. "storeId"

Correct Answer: B

To perform an inner join between DataFrame storeDF and DataFrame employeesDF on the column storeId, using the join method, the correct syntax requires specifying the DataFrame to join, the key column to join on, and the type of join as the last argument. The correct code block is: storesDF.join(employeesDF, "storeId", "inner").

Discussion

Raju_BhaiOption: B

correct syatx=> df.join(x, KEY, 'inner'), so option B

thanabOption: B

B is correct.

Ram459Option: B

B looks to be right

zozoshankyOption: B

B is correct

cookiemonster42

agreed, mate, it's B, the type is the last argument

azure_bimonsterOption: B

this is the right one