ExamTopics Logo
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam
Go to Exam

Exam Certified Data Engineer Associate topic 1 question 17 discussion

Actual exam question from Databricks's Certified Data Engineer Associate
Question #: 17
Topic #: 1
[All Certified Data Engineer Associate Questions]

A data engineer needs to apply custom logic to string column city in table stores for a specific use case. In order to apply this custom logic at scale, the data engineer wants to create a SQL user-defined function (UDF).
Which of the following code blocks creates this SQL UDF?

  • A.
  • B.
  • C.
  • D.
  • E.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by Flexron at March 31, 2023, 1:05 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Flexron
Highly Voted 2 years, 2 months ago
E is wrong, the right answer is A. https://www.databricks.com/blog/2021/10/20/introducing-sql-user-defined-functions.html
upvoted 15 times
...
XiltroX
Highly Voted 2 years, 2 months ago
Selected Answer: A
The answer E is incorrect. A user defined function is never written as CREATE UDF. The correct way is CREATE FUNCTION. So that leaves us with the choices A and D. Out of that, in D, there is no such thing as RETURN CASE so the correct answer is A.
upvoted 9 times
Redwings538
2 years, 1 month ago
Both A and D use RETURN CASE
upvoted 5 times
...
...
SoumyaHK
Most Recent 1 month, 3 weeks ago
Selected Answer: A
The response is A
upvoted 1 times
...
Ani_Ni
9 months, 2 weeks ago
A and D
upvoted 1 times
...
3fbc31b
11 months, 2 weeks ago
Selected Answer: A
A is the correct syntax for creating a UDF in Databricks.
upvoted 1 times
...
benni_ale
1 year, 1 month ago
Selected Answer: A
A is correct
upvoted 1 times
...
a_51
1 year, 3 months ago
Selected Answer: A
https://docs.databricks.com/en/udf/index.html#language-sql Answer E is not correct when having CREATE UDF rather than CREATE FUNCTION
upvoted 1 times
...
isamrat28
1 year, 4 months ago
Correct Answer is A
upvoted 1 times
...
agAshish
1 year, 4 months ago
D, should be the answer. The fucntion is not returning STRING , it is applied on a string column
upvoted 3 times
...
SerGrey
1 year, 5 months ago
Selected Answer: A
Correct answer is A
upvoted 1 times
...
Huroye
1 year, 7 months ago
Correct answer is A. It is not E. First, you do not need to specify "UDF" in the syntax. You need to specify the return type and then what you want to return, usually your processed output. CREATE FUNCTION myUDF(udf STRING) RETURNS STRING <...udf....>
upvoted 4 times
...
VijayKula
1 year, 8 months ago
Selected Answer: A
Create Function Return String
upvoted 1 times
...
VijayKula
1 year, 8 months ago
Selected Answer: A
Correct is A
upvoted 1 times
...
DavidRou
1 year, 8 months ago
A is the right answer. The template to use is the following: CREATE FUNCTION <name_function> (<function_parameter>, ..) RETURNS <return_type> <body>
upvoted 2 times
...
AtanuChat
1 year, 8 months ago
First need create a function and then need to register it as UDF
upvoted 1 times
...
KalavathiP
1 year, 8 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
d_b47
1 year, 8 months ago
Selected Answer: A
no UDF only FUNCTION needed.
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel