Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Certified Associate Developer for Apache Spark All Questions

View all questions & answers for the Certified Associate Developer for Apache Spark exam

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

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 Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
cd6a625
4 months, 2 weeks ago
Selected Answer: D
D is the correct answer
upvoted 1 times
...
SaiPavan10
7 months, 3 weeks ago
Selected Answer: C
D is the right choice.
upvoted 1 times
...
veli4ko
1 year, 1 month ago
D is correct
upvoted 2 times
...
thanab
1 year, 2 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, 3 months ago
Selected Answer: D
yup D is correct
upvoted 2 times
...
zozoshanky
1 year, 3 months ago
D is the answer
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...