Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Mulesoft Discussions
exam questions

Exam MCD - Level 1 All Questions

View all questions & answers for the MCD - Level 1 exam
Go to 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 🗳️
by AntarJalil at Jan. 23, 2024, 10:28 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
e10c971
7 months, 1 week ago
why is not C , 90001should not be processed after 90009?
upvoted 1 times
...
Alandt
9 months, 3 weeks ago
Selected Answer: A
A is correct
upvoted 1 times
...
Geo_2523
9 months, 3 weeks 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
10 months 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
10 months 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
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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