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

Certified Associate Developer for Apache Spark 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"

Show Answer

Correct Answer: BD

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

5 comments

zozoshankyOption: B

Jul 30, 2023

B is correct

cookiemonster42

Aug 2, 2023

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

Ram459Option: B

Aug 16, 2023

B looks to be right

thanabOption: B

Sep 12, 2023

B is correct.

Raju_BhaiOption: B

Oct 12, 2023

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

azure_bimonsterOption: B

Feb 9, 2024

this is the right one