Certified Associate Developer for Apache Spark Exam

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

Question 135

The code block shown below should return a new DataFrame where column division from DataFrame storesDF has been renamed to column state and column managerName from DataFrame storesDF has been renamed to column managerFullName. Choose the response that correctly fills in the numbered blanks within the code block to complete this task.

Code block:

storesDF. __1__(__2__, __2__).__4__(__5__, __6__)

1. withColumnRenamed

2."state"

3."division"

4.withColumnRenamed

5."managerFullName"

6."managerName"

1.withColumnRenamed

2.division

3.col("state")

4. withColumnRenamed

5."managerName"

6.col("managerFullName")

1. WithColumnRenamed

2. "division"

3."state"

4. withColumnRenamed

5. "managerName"

6."managerFullName"

1. withColumn

2. "division"

3. "state"

4.withcolumn

5."managerName"

6."managerFullName

1. withColumn

2. "division"

3. "state"

4. withColumn

5."managerName"

6."managerFullName"

Correct Answer: C

To rename columns in a DataFrame, the correct function is 'withColumnRenamed'. The syntax should follow 'sourceColName' and then 'newColName'. Therefore, the correctly filled in blanks are: storesDF.withColumnRenamed('division', 'state').withColumnRenamed('managerName', 'managerFullName').

Discussion

azure_bimonsterOption: C

C is correct from these scenarios

amirshazOption: C

columnRenamed(sourceColName, newColName)

gowthamsaraOption: C

C is correct