Câu 65: Databricks Certified Associate Developer for Apache Spark

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”)

1. A. The customerSatisfaction column cannot be called twice inside the SQL statement.
2. B. Registered UDFs cannot be applied inside of a SQL statement.
3. C. The order of the arguments to spark.udf.register() should be reversed.
4. D. The wrong SQL function is used to compute column result - it should be ASSESS_PERFORMANCE instead of assessPerformance. — đáp án hiện tại
5. E. There is no sql() operation - the DataFrame API must be used to apply the UDF assessPerformance().