The situation
An Opportunity object already has several business automations. A new requirement must update Opportunity fields, update related records, perform non-trivial data processing, and remain maintainable as transaction volume and automation complexity grow. The admin team must retain visibility into the business process, while developers need strong control over performance and failure handling. Would you implement this with Flow, Apex, or a hybrid approach? Explain the trade-offs and how your choice would change for low, medium, and high automation density.
Consider in your response
- Flow vs Apex architectural trade-offs
- Automation density
- Bulk-processing and performance considerations
- Maintainability and governance
- Flow + Invocable Apex hybrid architecture
- Transaction-control requirements
- Single automation entry-point strategy
