Databricks Exam Databricks-Certified-Data-Analyst-Associate Topic 1 Question 30 Discussion

Actual exam question for Databricks's Databricks-Certified-Data-Analyst-Associate exam

Question #: 30
Topic #: 1

[All Databricks-Certified-Data-Analyst-Associate Questions]

A data analyst has created a user-defined function using the following line of code:

CREATE FUNCTION price(spend DOUBLE, units DOUBLE)

RETURNS DOUBLE

RETURN spend / units;

Which of the following code blocks can be used to apply this function to the customer_spend and customer_units columns of the table customer_summary to create column customer_price?

ASELECT PRICE customer_spend, customer_units AS customer_price FROM customer_summary

BSELECT price FROM customer_summary

CSELECT function(price(customer_spend, customer_units)) AS customer_price FROM customer_summary

DSELECT double(price(customer_spend, customer_units)) AS customer_price FROM customer_summary

ESELECT price(customer_spend, customer_units) AS customer_price FROM customer_summary

Show Suggested Answer

Suggested Answer: E

A user-defined function (UDF) is a function defined by a user, allowing custom logic to be reused in the user environment1.To apply a UDF to a table, the syntax isSELECT udf_name(column_name) AS alias FROM table_name2. Therefore, option E is the correct way to use the UDFpriceto create a new columncustomer_pricebased on the existing columnscustomer_spendandcustomer_unitsfrom the tablecustomer_summary.Reference:

What are user-defined functions (UDFs)?

User-defined scalar functions - SQL

by Tegan at Dec 06, 2024, 04:46 PM

Limited Time Offer

25%

12 days ago

Option E is the correct answer. It directly applies the user-defined function to the columns and creates the new column as specified.

upvoted 0 times

Francoise

2 days ago

Option E is the correct answer. It directly applies the user-defined function to the columns and creates the new column as specified.

upvoted 0 times

...