An engineer joins facts to a dimension with duplicate business keys and totals unexpectedly increase. What is the likely issue?

1. A guaranteed failure of Delta transaction logging
2. A many-to-many expansion from duplicate join matches
3. Automatic conversion of the join to a union
4. A lower warehouse idle timeout