nerdexam
Databricks

DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK · Question #65

The code block shown below should efficiently perform a broadcast join of DataFrame storesDF and the much larger DataFrame employeesDF using key column storeId. Choose the response that correctly…

The correct answer is D. 1. storesDF. See the full explanation below for the reasoning.

Spark DataFrame Operations and Optimizations

Question

The code block shown below should efficiently perform a broadcast join of DataFrame storesDF and the much larger DataFrame employeesDF using key column storeId. Choose the response that correctly fills in the numbered blanks within the code block to complete this task. Code block:

1.join(2(3), "storeId")

Options

  • A
    1. employeesDF
  • B
    1. broadcast(employeesDF)
  • C
    1. broadcast
  • D
    1. storesDF
  • E
    1. broadcast(storesDF)

How the community answered

(29 responses)
  • A
    3% (1)
  • D
    93% (27)
  • E
    3% (1)

Topics

#Spark DataFrame Joins#Broadcast Join#Spark SQL API#Performance Tuning

Community Discussion

No community discussion yet for this question.

Full DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Practice