Finance must move funds across multiple appropriation accounts in one ACID transaction with multi-row SQL updates. Which data store choice fits best for the application?
Select an answer to reveal the explanation.
Short Explanation
When several account rows must succeed or fail together, you want a real SQL transaction—Aurora or RDS—not a hope that a single PutItem covers the whole ledger.
Full Explanation
Multi-row ACID transfers across related accounts map naturally to relational databases such as Aurora or RDS. DynamoDB supports transactions, but complex multi-entity financial transfers with SQL joins and relational constraints are a classic Aurora/RDS fit. S3 and ElastiCache are not transactional systems of record for appropriation ledgers.