Câu 16: Databricks Certified Data Analyst Associate
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…
Nội dung câu hỏi
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?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. SELECT PRICE customer_spend, customer_units AS customer_priceFROM customer_summary
- B. SELECT price -FROM customer_summary
- C. SELECT function(price(customer_spend, customer_units)) AS customer_priceFROM customer_summary
- D. SELECT double(price(customer_spend, customer_units)) AS customer_priceFROM customer_summary
- E. SELECT price(customer_spend, customer_units) AS customer_priceFROM customer_summary — đáp án hiện tại
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.