Databricks Certified Data Engineer - Associate

Get started today

Ultimate access to all questions.

Deep dive into the quiz with AI chat providers.

We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.

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

Last updated: February 3, 2026 at 14:03

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;

CREATE UDF combine_nyc(city STRING)
RETURNS STRING
CASE
    WHEN city = "brooklyn" THEN "new york"
    ELSE city
END;

CREATE UDF combine_nyc(city STRING)
RETURNS STRING
CASE
    WHEN city = "brooklyn" THEN "new york"
    ELSE city
END;

CREATE UDF combine_nyc(city STRING)
RETURN CASE
    WHEN city = "brooklyn" THEN "new york"
    ELSE city
END;

CREATE UDF combine_nyc(city STRING)
RETURN CASE
    WHEN city = "brooklyn" THEN "new york"
    ELSE city
END;

(No code provided)

Explanation:

Explanation

The correct answer is Option A.

Why Option A is correct:

Proper SQL UDF syntax: In Databricks SQL, user-defined functions are created using CREATE FUNCTION syntax, not CREATE UDF.
Complete syntax: The function includes:
- CREATE FUNCTION statement
- Function name and parameter definition combine_nyc(city STRING)
- Return type specification RETURNS STRING
- RETURN keyword before the CASE expression
- Proper CASE expression syntax
Valid Databricks SQL: This follows the standard SQL UDF syntax supported by Databricks.

Why other options are incorrect:

Option B: Uses CREATE UDF instead of CREATE FUNCTION, which is not valid SQL syntax in Databricks.
Option C: Uses CREATE UDF and also misses the RETURNS STRING clause and the RETURN keyword before the CASE expression.
Option D: No code provided, so it cannot create a SQL UDF.

Key points for Databricks SQL UDFs:

Use CREATE FUNCTION statement
Specify return type with RETURNS
Use RETURN keyword before the function body
Functions can be used in SQL queries just like built-in functions
UDFs can be temporary or permanent depending on the use case

Powered ByGPT-5.2

Comments

Loading comments...