Which AWS solutions can provide the transactional capability that is required for this feature?
(Choose two.)
Amazon DynamoDB with operations made with the ConsistentRead 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 with ConsistentRead does not provide transactional capabilities; it allows reading consistent data but does not support atomic updates across multiple items or records in a transaction.
Amazon ElastiCache for Memcached does not support transactions. It is primarily a caching solution, and while it can be used to improve performance, it does not ensure atomicity or rollback capabilities for operations on game items.
Amazon DynamoDB offers transactional support through Transact* operations, which allow multiple read and write operations to be executed atomically. If any operation in the transaction fails, all changes are rolled back.
Amazon Aurora MySQL supports transactions using SQL transaction blocks (BEGIN, COMMIT, ROLLBACK). This ensures that multiple operations are executed atomically, and if any operation fails, the transaction can be rolled back to maintain data integrity.
Amazon Athena is designed for querying data in S3 using SQL but does not support transactional capabilities. It does not allow for the execution of multiple operations in a transaction that can be rolled back.