Exam Databricks-Certified-Data-Engineer-Associate Topic 1 Question 148 Discussion

Actual exam question for Databricks's Databricks-Certified-Data-Engineer-Associate exam
Question #: 148
Topic #: 1

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. sql
CREATE FUNCTION city_custom_logic(city STRING)
RETURNS STRING
RETURN CASE
WHEN city = 'London' THEN 'LND'
ELSE city
END; B. sql
CREATE UDF city_custom_logic(city STRING)
RETURNS STRING
AS
SELECT CASE WHEN city = 'London' THEN 'LND' ELSE city END; C. sql
DEFINE FUNCTION city_custom_logic(city STRING)
AS STRING
RETURN CASE WHEN city = 'London' THEN 'LND' ELSE city END; D. sql
CREATE FUNCTION city_custom_logic(city STRING)
AS
IF city = 'London' THEN 'LND' ELSE city END;

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business