Summer Certification Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: force70

Databricks Certified Data Analyst Associate Exam Databricks-Certified-Data-Analyst-Associate Question # 24 Topic 3 Discussion

Databricks Certified Data Analyst Associate Exam Databricks-Certified-Data-Analyst-Associate Question # 24 Topic 3 Discussion

Databricks-Certified-Data-Analyst-Associate Exam Topic 3 Question 24 Discussion:
Question #: 24
Topic #: 3

A data analyst is working with the following table my_table:

customer_name dollars_spent

Hex Sprockets [125.34, 100.15, 9003.99]

Dented Fenders [16.99, 200.85, 33.49, 88.17]

The analyst wants to divide each value in the dollars_spent array by 100 to get the spend in terms of hundreds of dollars using the following code block:

SELECT

customer_name,

_______

FROM my_table;

Which line of code can be used to fill in the blank so that the above code block successfully completes the task?


A.

TRANSFORM(hundreds_spent, dollars_spent / 100)


B.

TRANSFORM(dollars_spent, value / 100) AS hundreds_spent


C.

TRANSFORM(dollars_spent, value - > value / 100) AS hundreds_spent


D.

TRANSFORM(dollars_spent, dollars_spent / 100) AS hundreds_spent


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.