Databricks Certified Data Analyst Associate Exam Databricks-Certified-Data-Analyst-Associate Question # 7 Topic 1 Discussion

Databricks Certified Data Analyst Associate Exam Databricks-Certified-Data-Analyst-Associate Question # 7 Topic 1 Discussion

Databricks-Certified-Data-Analyst-Associate Exam Topic 1 Question 7 Discussion:
Question #: 7
Topic #: 1

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?


A.

SELECT PRICE customer_spend, customer_units AS customer_price FROM customer_summary


B.

SELECT price FROM customer_summary


C.

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


D.

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


E.

SELECT price(customer_spend, customer_units) AS customer_price FROM customer_summary


Get Premium Databricks-Certified-Data-Analyst-Associate Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.