ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 12 - MCD - Level 1 discussion

Report
Export

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?

A.
Set the watermark column to the bgin_date_time column
Answers
A.
Set the watermark column to the bgin_date_time column
B.
Set the target value to the last retrieved login_date_time value
Answers
B.
Set the target value to the last retrieved login_date_time value
C.
Set the target value to the last retrieved user_jd value
Answers
C.
Set the target value to the last retrieved user_jd value
D.
Set the watermark column to the user_Id column
Answers
D.
Set the watermark column to the user_Id column
Suggested answer: A

Explanation:

* Watermark allows the poll scope to poll for new resources instead of getting the same resource over and over again.

* The database table must be ordered so that the ''watermark functionality'' can move effectively in the ordered list. Watermark stores the current/last picked up ''record id.''

* If the Mule application is shut down, it will store the last picked up ''record id'' in the Java Object Store and the data will continue to exist in the file. This watermark functionality is valuable and enables developers to have increased transparency.

* Developers do not need to create code to handle caching; it is all configurable!

* There are two columns and both are unique but user_id can't guaranty sequence whereas date_time will always be in increasing order and table content can easily be ordered on the basis of last processed date_time.

So correct answer is: Set the watermark column to the date_time column

asked 18/09/2024
Mohamed Ismail
49 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first