You are a data engineer responsible for designing a data pipeline that processes customer transactions in real-time for a financial services company. The pipeline must ensure high data integrity and compliance with financial regulations. During the design phase, you are evaluating how to handle constraint violations, such as duplicate transactions or transactions exceeding account limits. The pipeline must continue to process valid transactions without significant delays, even when violations occur. Considering these requirements, which of the following mechanisms would you implement to handle constraint violations effectively? Choose the best option.