News / Exam Questions

This question has been asked by one of our members and a similar question could most likely be on the exam. All answers have been verified by MuleSoft certified FoMS experts.

Question

An On Table Row Database listener retrieves data from a table that contains record_id, an increasing numerical column. How should the listener be configured so it retrieves new rows at most one time?

Answer

A) Set the target to store the last retrieved record_id value
B) Set the ObjectStore to store the last retrieved record_id value
C) Set the target to the record_id column
D) Set the watermark column to the record id column

The correct answer to this question is D.

Explanation

Since the table contains an increasing numerical column (record_id), we can use watermark to retrieve only new rows from the table. In case we would like to work with a manual watermarking, we would use ObjectStore, but this is not the case so the correct answer is D.