MuleSoft Certified Developer – Level 1 — Question 83

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

Answer options

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

Correct answer: C

Explanation

The Watermark column is crucial for the On Table Row operation as it helps prevent the processing of duplicate records by keeping track of the last processed record. Options A and D imply actions that could lead to caching issues or data loss, while option B contradicts the function of the Watermark by suggesting it enables duplicate processing, which is not its purpose.