Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Certified Data Engineer Associate All Questions

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

Exam Certified Data Engineer Associate topic 1 question 62 discussion

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

A data engineer needs to apply custom logic to identify employees with more than 5 years of experience in array column employees in table stores. The custom logic should create a new column exp_employees that is an array of all of the employees with more than 5 years of experience for each row. In order to apply this custom logic at scale, the data engineer wants to use the FILTER higher-order function.

Which of the following code blocks successfully completes this task?

  • A.
  • B.
  • C.
  • D.
  • E.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
benni_ale
7 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
AndreFR
11 months, 1 week ago
Selected Answer: A
B & E incorrect : source is employees not exp_employees D incorrect : does not use FILTER higher-order function) C incorrect : syntax errror A : correct by elimination & based on https://docs.databricks.com/en/sql/language-manual/functions/filter.html#examples
upvoted 2 times
...
kz_data
11 months, 3 weeks ago
Selected Answer: A
A is correct
upvoted 2 times
...
55f31c8
12 months ago
Selected Answer: A
https://docs.databricks.com/en/sql/language-manual/functions/filter.html
upvoted 3 times
...
meow_akk
1 year, 1 month ago
A is correct.
upvoted 4 times
...
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
Loading ...