MuleSoft
MCD-LEVEL-1 · Question #23
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?
The correct answer is D. Set the watermark column to the record id column. You've hit your limit · resets 5am (America/New_York)
Consume and Transform Data
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?
Options
- ASet the target to store the last retrieved record_id value
- BSet the ObjectStore to store the last retrieved record_id value
- CSet the target to the record_id column
- DSet the watermark column to the record id column
How the community answered
(34 responses)- A3% (1)
- B12% (4)
- C9% (3)
- D76% (26)
Explanation
You've hit your limit · resets 5am (America/New_York)
Topics
#Database connector#watermark#On Table Row listener#polling
Community Discussion
No community discussion yet for this question.