nerdexam
MuleSoft

MCD-LEVEL-1 · Question #179

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

The correct answer is A. To avoid duplicate processing of records in a database. 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…

Build Mule applications using Mule components

Question

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

Options

  • ATo avoid duplicate processing of records in a database.
  • BTo delete the most recent records retrieved from a database to enable database caching
  • CTo enable duplicate processing of records in a database
  • DTo save the most recent records retrieved from a database to enable database caching

How the community answered

(39 responses)
  • A
    87% (34)
  • B
    3% (1)
  • C
    8% (3)
  • D
    3% (1)

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 Mule doc reference : https://docs.mulesoft.com/db-connector/1.8/database- documentation#listener

Topics

#Database connector#watermark#On Table Row#duplicate processing

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full MCD-LEVEL-1 Practice