MuleSoft Exam MCD-Level1-Delta Topic 1 Question 3 Discussion

Actual exam question for MuleSoft's MCD-Level1-Delta exam

Question #: 3
Topic #: 1

A Database On Table Row listener retrieves data from a CUSTOMER table that contains a primary key userjd column and an increasing kxjin_date_time column. Neither column allows duplicate values.

How should the listener be configured so it retrieves each row at most one time?

ASet the watermark column to the bgin_date_time column

BSet the target value to the last retrieved login_date_time value

CSet the target value to the last retrieved user_jd value

DSet the watermark column to the user_Id column

Show Suggested Answer

Suggested Answer: A

by Kimbery at Apr 08, 2024, 01:57 AM

Limited Time Offer

25%

Off

Get Premium MCD-Level1-Delta Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Carrol

1 days ago

I disagree, I believe setting the target value to the last retrieved login_date_time value is the correct configuration.

upvoted 0 times

...

Adelina

2 days ago

I think the listener should be configured to set the watermark column to the user_Id column.

upvoted 0 times

...

You know what, I'm just going to go with option B. Setting the target value to the last retrieved login_date_time value sounds the most straightforward to me. Worst case, I can always explain my reasoning if I get it wrong.

upvoted 0 times

...

Vonda

24 days ago

Hmm, I think the key here is to use the right columns as the watermark and target value. Since the user_id column and the login_date_time column are both unique, we need to use one of them to ensure we don't retrieve the same row multiple times.

upvoted 0 times

...

Mireya

26 days ago

I'm not too sure about this question. The options seem a bit confusing to me. How are we supposed to configure the listener to retrieve each row at most one time?

upvoted 0 times

...

MuleSoft Exam MCD-Level1-Delta Topic 1 Question 3 Discussion

Contribute your Thoughts:

Carrol

Adelina

Lauran

Vonda

Mireya