Data Engineering Associate with Databricks Practice Exam

Which SQL statement would you use to create a simple UDF that converts text to uppercase?

1. CREATE OR REPLACE FUNCTION uppercase(text STRING)

2. CREATE FUNCTION yell(text STRING)

3. CREATE OR REPLACE FUNCTION yelling(text STRING)

4. FUNCTION yelling(text STRING)

The correct answer is: CREATE OR REPLACE FUNCTION yelling(text STRING)

The choice to create a simple User Defined Function (UDF) that converts text to uppercase is best represented by using the syntax found in option C. In SQL, particularly within environments like Databricks, the `CREATE OR REPLACE FUNCTION` statement is standard for defining or updating a UDF. The capability to "replace" allows flexibility in modifying an existing function without the need for manual deletion beforehand. The function name "yelling" suggests that its purpose may be related to converting text to uppercase—drawing a parallel to the idea of "yelling" when one speaks in all capital letters. When associated with a string input parameter, the function can be designed to output the uppercase version of the input text. In contrast, while option A shows a similar function definition pattern, it does not align with the naming convention that would suggest the function's purpose. The names "uppercase" and "yelling" serve different implications, with "yelling" being more expressive regarding the function's intended effect. Options B and D provide forms of syntax that are not fully valid for creating a UDF in SQL within Databricks, as they do not include the necessary `CREATE` keyword for function creation, thus failing to express the full intent