Databricks Certified Data Engineer - Associate
Get started today
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?
Real Exam
Community
KKeng
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.)
Explanation:
Explanation
Option A is the correct syntax for creating a SQL user-defined function (UDF) in Databricks:
- Correct Syntax:
CREATE FUNCTIONis the proper SQL command to create a user-defined function. - Parameter Definition:
(city STRING)correctly defines the input parameter. - Return Type:
RETURNS STRINGproperly specifies the return type. - Function Body: The
RETURN CASE...END;structure correctly implements the function logic. - Complete Statement: The statement ends with a semicolon, making it syntactically complete.
Option B is incorrect because:
- Wrong Command: Uses
CREATE UDFinstead ofCREATE FUNCTION. - Incomplete Syntax: Missing the
RETURNkeyword before the CASE statement. - Missing END: The CASE statement doesn't have an
ENDkeyword. - Missing Semicolon: The statement is incomplete without a closing semicolon.
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.
Comments
Loading comments...