Exam Certified Associate Developer for Apache Spark topic 1 question 105 discussion

Actual exam question from Databricks's Certified Associate Developer for Apache Spark

Question #: 105
Topic #: 1

[All Certified Associate Developer for Apache Spark Questions]

The code block shown below contains an error. The code block is intended to create and register a SQL UDF named “ASSESS_PERFORMANCE” using the Scala function assessPerformance() and apply it to column customerSatisfaction in the table stores. Identify the error.

Code block:

spark.udf.register(“ASSESS_PERFORMANCE”, assessPerforance)
spark.sql(“SELECT customerSatisfaction, assessPerformance(customerSatisfaction) AS result FROM stores”)

A. The customerSatisfaction column cannot be called twice inside the SQL statement.
B. Registered UDFs cannot be applied inside of a SQL statement.
C. The order of the arguments to spark.udf.register() should be reversed.
D. The wrong SQL function is used to compute column result - it should be ASSESS_PERFORMANCE instead of assessPerformance.
E. There is no sql() operation - the DataFrame API must be used to apply the UDF assessPerformance().

Show Suggested Answer

Suggested Answer: D 🗳️

by zozoshanky at July 30, 2023, 9:20 p.m.

Comments

Submit Cancel

cd6a625

1 year ago

Selected Answer: D

D is the correct answer

upvoted 1 times

...

SaiPavan10

1 year, 3 months ago

Selected Answer: C

D is the right choice.

upvoted 1 times

...

veli4ko

1 year, 9 months ago

D is correct

upvoted 2 times

...

thanab

1 year, 10 months ago

D The error in the code block is D. The wrong SQL function is used to compute column result - it should be ASSESS_PERFORMANCE instead of assessPerformance.

upvoted 1 times

...

Ram459

1 year, 10 months ago

Selected Answer: D

yup D is correct

upvoted 2 times

...

zozoshanky

1 year, 11 months ago

D is the answer

upvoted 2 times

...