Which SQL DDL statement correctly creates a User-Defined Function (UDF) to convert distance values between Miles and Kilometers, returning the input value for any other distance measure?

Real Exam

CREATE UDF convert_distance(distance DOUBLE, measure STRING)RETURN CASE WHEN measure = “Miles“ THEN (distance * 1.60934) WHEN measure = “KM“ THEN (distance * 0.621371) ELSE distanceEND;_

2.8%

CREATE UDF FUNCTION convert_distance(distance DOUBLE, measure STRING)RETURNCASE WHEN measure = “Miles“ THEN (distance * 1.60934) WHEN measure = “KM“ THEN (distance * 0.621371) ELSE distanceEND;_

5.6%

CREATE FUNCTION convert_distance(distance DOUBLE, measure STRING)RETURNCASE WHEN measure = “Miles“ THEN (distance * 1.60934) WHEN measure = “KM“ THEN (distance * 0.621371) ELSE distanceEND;_

14.8%

CREATE FUNCTION convert_distance(distance DOUBLE, measure STRING)RETURNS DOUBLERETURNCASE WHEN measure = “Miles“ THEN (distance * 1.60934) WHEN measure = “KM“ THEN (distance * 0.621371) ELSE distanceEND;_

71.8%

CREATE UDF convert_distance(distance DOUBLE, measure STRING)RETURNS DOUBLERETURNCASE WHEN measure = “Miles“ THEN (distance * 1.60934) WHEN measure = “KM“ THEN (distance * 0.621371) ELSE distanceEND;_

4.9%

Databricks Certified Data Engineer - Associate

Get started today

Comments

Which SQL DDL statement correctly creates a User-Defined Function (UDF) to convert distance values between Miles and Kilometers, returning the input value for any other distance measure?