Question 640
A fraud analyst needs the newest event per account without grouping away the rest of the event columns. Initial testing shows: Each account returns one truly latest event even on equal timestamps. Which limitation should the team still consider?
Explanation
Correct Answer
Without a deterministic tie-breaker the selected row can vary. ROW_NUMBER over a partition and deterministic ordering can select one latest row per key.
Incorrect Answers
Latest-row selection needs row correlation; ROW_NUMBER with partition/order can retain the correct event fields.
Ties are nondeterministic without a stable secondary sort key such as EventId; test duplicate timestamps.
Partitioning is what resets the ranking for each account; global ranking silently omits most accounts.