Explanation:
Option A is the correct syntax for creating a SQL user-defined function (UDF) in Databricks:
CREATE FUNCTION is the proper SQL command to create a user-defined function.(city STRING) correctly defines the input parameter.RETURNS STRING properly specifies the return type.RETURN CASE...END; structure correctly implements the function logic.Option B is incorrect because:
CREATE UDF instead of CREATE FUNCTION.RETURN keyword before the CASE statement.END keyword.In Databricks SQL, user-defined functions are created using the CREATE FUNCTION syntax, which allows you to define reusable SQL logic that can be applied at scale across multiple queries and tables.
Ultimate access to all questions.
A data engineer needs to apply custom logic to string column city in table stores for a specific use case. In order to apply this custom logic at scale, the data engineer wants to create a SQL user-defined function (UDF). Which of the following code blocks creates this SQL UDF?
A
CREATE FUNCTION combine_nyc (city STRING)
RETURNS STRING
RETURN CASE
WHEN city = "brooklyn" THEN "new york"
ELSE city
END;
CREATE FUNCTION combine_nyc (city STRING)
RETURNS STRING
RETURN CASE
WHEN city = "brooklyn" THEN "new york"
ELSE city
END;
B
CREATE UDF combine_nyc(city STRING)
RETURNS STRING
CASE
WHEN city = "brooklyn" THEN "new york"
ELSE city
CREATE UDF combine_nyc(city STRING)
RETURNS STRING
CASE
WHEN city = "brooklyn" THEN "new york"
ELSE city
(Note: Option B is incomplete and syntactically incorrect for standard SQL UDF creation.)
No comments yet.