A pipeline joins order records to customers, but some orders refer to nonexistent customer identifiers. Which approach best fits?

1. Remove target leakage and rebuild an appropriately timed evaluation split.
2. Add business-rule validation for value range and currency consistency.
3. Validate referential relationships and quarantine or resolve orphaned records.
4. Profile the source data and compare results with expected constraints.