Exam MCD - Level 1 All QuestionsBrowse all questions from this exam
Go to Exam
Question 150

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?

    Correct Answer: A

    When the Mule application runs and the On Table Row Database listener polls the Address table for the first time, it processes all existing records and sets the watermark to the highest ZIPCODE value, which is 90009. Therefore, the rows with ID 1 (ZIPCODE 90001), ID 2 (ZIPCODE 90005), ID 3 (ZIPCODE 90009), and ID 4 (ZIPCODE 90001) are processed. After the new row with ID 5 (ZIPCODE 90006) is added, the listener will not process this new entry since the ZIPCODE 90006 is less than the current watermark, which is 90009. Therefore, the rows that have been processed since the Mule application was started include only the initial rows.

Discussion
AntarJalilOption: A

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.

Geo_2523Option: 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.

e10c971Option: D

why is not C , 90001should not be processed after 90009?

AlandtOption: A

A is correct

ExamDevOption: 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.