A batch upsert receives multiple source rows for the same target key. What should the engineer do before applying it?

1. Resolve source duplicates with a deterministic business rule
2. Assume MERGE chooses the newest automatically
3. Change the target key to a random value per retry
4. Remove all target uniqueness requirements