Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Flexron
Highly Voted 1 year, 8 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 14 times
...
XiltroX
Highly Voted 1 year, 7 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 7 times
Redwings538
1 year, 6 months ago
Both A and D use RETURN CASE
upvoted 4 times
...
...
Ani_Ni
Most Recent 2 months, 3 weeks ago
A and D
upvoted 1 times
...
3fbc31b
4 months, 2 weeks ago
Selected Answer: A
A is the correct syntax for creating a UDF in Databricks.
upvoted 1 times
...
benni_ale
7 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
a_51
8 months, 2 weeks 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
9 months, 2 weeks ago
Correct Answer is A
upvoted 1 times
...
agAshish
9 months, 4 weeks ago
D, should be the answer. The fucntion is not returning STRING , it is applied on a string column
upvoted 3 times
...
SerGrey
10 months, 3 weeks ago
Selected Answer: A
Correct answer is A
upvoted 1 times
...
Huroye
1 year 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 3 times
...
VijayKula
1 year, 1 month ago
Selected Answer: A
Create Function Return String
upvoted 1 times
...
VijayKula
1 year, 1 month ago
Selected Answer: A
Correct is A
upvoted 1 times
...
DavidRou
1 year, 1 month 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, 1 month ago
First need create a function and then need to register it as UDF
upvoted 1 times
...
KalavathiP
1 year, 2 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
d_b47
1 year, 2 months ago
Selected Answer: A
no UDF only FUNCTION needed.
upvoted 1 times
...
akk_1289
1 year, 4 months ago
CORRECT ANSWER IS : A https://www.databricks.com/blog/2021/10/20/introducing-sql-user-defined-functions.html
upvoted 1 times
...
Load full discussion...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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