Which AWS solution can provide the transactional capability that is required for this feature?
Amazon DynamoDB with operations made with the Consistent Read parameter set to true
Amazon ElastiCache for Memcached with operations made within a transaction block
Amazon DynamoDB with reads and writes made by using Transact* operations
Amazon Aurora MySQL with operations made within a transaction block
Amazon Athena with operations made within a transaction block
Explanations:
Amazon DynamoDB provides scalability and performance for NoSQL workloads, but it does not support multi-item transactions with full rollback capabilities like relational databases or specifically designed transactional operations like Transact* in DynamoDB.
Amazon ElastiCache for Memcached is a caching service and does not support transactional capabilities or atomic operations for ensuring full rollbacks across multiple records.
Amazon DynamoDB provides Transact* operations that support ACID (Atomicity, Consistency, Isolation, Durability) properties, ensuring that multiple operations on multiple items can be executed within a single transaction and rolled back if any operation fails.
Amazon Aurora MySQL supports transactions, but this is a relational database service. While it could handle transactional integrity for this scenario, the question specifies a NoSQL-like solution for scalability and does not directly reference MySQL.
Amazon Athena is a query service for analyzing large datasets in S3 and does not support transactional operations or rollback functionality within a transactional context.