UDF — Learn free · DataAI Nexus

Self-check

Questions 1–10 of 10

1. What does UDF stand for?
Question 1A. Unified Data FormatB. User-Defined FunctionC. Universal Database FrameworkD. Unstructured Data FileE. Utility Deployment Function
2. What are the stated benefits of using User-Defined Functions?
Question 2A. Faster network transfer and smaller filesB. Automatic indexing and encryptionC. Encapsulating commonly used logic, promoting code reusability and enhancing readabilityD. Eliminating the need for testingE. Replacing built-in database functions entirely
3. What does the SQL UDF example ConcatenateStrings('Hello', 'World') return?
Question 3A. HelloWorldB. World HelloC. Hello, WorldD. Hello WorldE. Hello+World
4. What does the Python UDF calculate_square(5) output?
Question 4A. 10B. 5C. 50D. 2.5E. 25
5. What does the JavaScript UDF isEven(7) return?
Question 5A. falseB. trueC. 7D. 1E. undefined
6. Which language is used to create custom functions (UDFs) in Microsoft Excel?
Question 6A. PythonB. Visual Basic for Applications (VBA)C. SQLD. JavaScriptE. Scala
7. What result does the Excel UDF =Factorial(5) produce?
Question 7A. 25B. 15C. 120D. 5E. 720
8. In the PySpark UDF example, what does the uppercase_udf do when applied to the DataFrame?
Question 8A. Removes duplicate fruit namesB. Counts the number of fruitsC. Sorts the fruit column alphabeticallyD. Adds a new column upper_fruit containing the fruit names converted to uppercaseE. Deletes the fruit column
9. In the Spark UDF example, what is passed alongside the Python function when registering the UDF?
Question 9A. The DataFrame it will run onB. The Spark application nameC. A column nameD. A file pathE. The return type, StringType()
10. Which of the following is NOT one of the UDF environments given as an example?
Question 10A. RB. SQLC. PythonD. JavaScriptE. Apache Spark