mcd-level-1 question 179 discussion

View all MuleSoft Certified Developer - Level 1 (Mule 4) Exam here
back to mulesoft forum

Question 179

In the Database On Table Row operation, what does the Watermark column enable the On Table Row
operation to do?

  • A. To avoid duplicate processing of records in a database. Most Votes
  • B. To delete the most recent records retrieved from a database to enable database caching
  • C. To enable duplicate processing of records in a database
  • D. To save the most recent records retrieved from a database to enable database caching
Answer:

A


Explanation:
The correct answer is To avoid duplicate processing of records in a database.
If a watermark column is provided, the values taken from that column are used to filter the contents
of the next poll, so that only rows with a greater watermark value are returned. If an ID column is
provided, this component automatically verifies that the same row is not picked twice by concurrent
polls.
Mule
doc
reference
:
https://docs.mulesoft.com/db-connector/1.8/database-
documentation#listener

User Votes:
A 12 votes
50%
B
50%
C 1 votes
50%
D 3 votes
50%
Discussions
0 / 1000
d.abbas
11 months ago

The Watermark column in the Database On Table Row operation enables the operation to do the following:

A. To avoid duplicate processing of records in a database.

So, the correct answer is A. It allows the operation to prevent duplicate processing of records in a database by tracking the last processed record's watermark and ensuring that only new records are processed.

0