How does extract pick latest record if that does not have latest timestamp

Summary:

How does extract pick latest record if that does not have latest timestamp

Content (please ensure you mask any confidential information):

Hi Team,

Greetings!

We are currently an issue with the extract run picking up the penultimate record for the changes made.

There has been mass update and the latest record shows up with the new value. But the extract output includes the record which is just prior to the latest record.

It is not clear why this has happened for the given changes extract.

The only key observation we had is - that the latest record time-stamp (last_update_date) is a few seconds 'prior' to the penultimate record time-stamp.