To efficiently apply custom logic on a string column named 'city' in the 'location' table, a data engineer decides to create a SQL user-defined function (UDF). Which of the following code snippets correctly defines this SQL UDF?

Real Exam

CREATE UDF combine_california (city STRING)RETURN CASE WHEN city = “San Francisco“ THEN “California“ ELSE cityEND;_

5.0%

CREATE FUNCTION combine_california (city STRING)RETURNS STRINGCASE WHEN city = “San Francisco“ THEN “California“ ELSE cityEND;_

9.9%

CREATE FUNCTION combine_california (city STRING)RETURNS STRINGRETURN CASE WHEN city = “San Francisco“ THEN “California“ ELSE cityEND;_

62.9%

CREATE FUNCTION combine_california (city STRING)RETURN CASE WHEN city = “San Francisco“ THEN “California“ ELSE cityEND;_

16.8%

CREATE UDF combine_california (city STRING)RETURN CASE WHEN city = “San Francisco“ THEN “California“ ELSE cityEND;_

5.4%

Databricks Certified Data Engineer - Associate