Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam MCD - Level 1 All Questions

View all questions & answers for the MCD - Level 1 exam

Exam MCD - Level 1 topic 1 question 151 discussion

Actual exam question from Mulesoft's MCD - Level 1
Question #: 151
Topic #: 1
[All MCD - Level 1 Questions]

Refer to the exhibits. A database Address table contains a ZIPCODE column and an increasing ID column. The Address table currently contains four (4) records. The On Table Row Database listener is configured with its watermark set to the Address table's ZIPCODE column and then the Mule application is run in Anypoint Studio for the first time, and the On Table Row Database listener polls the Address table.





A new row is added to the database with ID=5 and ZIPCODE=90006, and then the On Table Row Database listener polls the database again.

After the next execution of the On Table Row Database listener polling, what database rows have been processed by the Mule flow since the Mule application was started?

  • A. ID ZIPCODE -
    1 90001
    2 90005
    3 90009
    4 90001
  • B. ID ZIPCODE -
    1 90001
    2 90005
    3 90009
    4 90001
    5 90006
  • C. ID ZIPCODE -
    1 90001
    2 90005
    3 90009
  • D. ID ZIPCODE -
    1 90001
    2 90005
    3 90009
    5 90006
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
e10c971
6 months, 2 weeks ago
why is not C , 90001should not be processed after 90009?
upvoted 1 times
...
Alandt
8 months, 4 weeks ago
Selected Answer: A
A is correct
upvoted 1 times
...
Geo_2523
9 months ago
Selected Answer: A
The watermark was set to the highest ZIPCODE value at that time, which was 90009. 90006 is less than 9009, therefore the new record was not processed. A is the right answer.
upvoted 2 times
...
ExamDev
9 months, 1 week ago
Selected Answer: B
row with ZIPCODE=90006 is greater than the current watermark (9001) value (which should be the maximum ZIPCODE processed), and it would be processed in the next execution of the listener.
upvoted 1 times
...
AntarJalil
9 months, 1 week ago
Correct answer : A. I have replicated the described scenario. In the first polling cycle, all four records shown in the provided screenshot were processed. The watermark was set to the highest ZIPCODE value at that time, which was 90009. Subsequently, when a new entry with ZIPCODE 90006 was inserted into the table, it was NOT processed. This is because 90006 is less than 90009. Therefore, the right answer is A.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...