A gaming site needs to update and persist both players' records in a single transaction so that if any update fails the entire transaction rolls back. Which AWS services or features can provide the required transactional behavior? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Amazon DynamoDB using the Transact* (transactional) read/write operations., Amazon Aurora MySQL using operations executed inside a database transaction block..
Why this is the answer
Amazon DynamoDB's TransactWriteItems and TransactReadItems operations provide atomicity, consistency, isolation, and durability (ACID) guarantees across multiple items within a single transaction, ensuring that all changes succeed or all fail. Amazon Aurora MySQL, being a relational database, inherently supports ACID transactions. Operations can be grouped within a BEGIN TRANSACTION; and COMMIT; block, or rolled back with ROLLBACK;, ensuring data consistency. DynamoDB with ConsistentRead set to true only ensures that a read operation returns the most recent data, but it does not provide transactional guarantees across multiple write operations. Amazon ElastiCache for Memcached is an in-memory key-value store primarily for caching and does not support transactional operations. Amazon Athena is a query service for analyzing data in Amazon S3 and does not support transactional updates to the underlying data.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed