AWS Certified Developer – Associate (DVA-C02) — Question 336

A gaming website gives users the ability to trade game items with each other on the platform. The platform requires both users' records to be updated and persisted in one transaction. If any update fails, the transaction must roll back.

Which AWS solutions can provide the transactional capability that is required for this feature? (Choose two.)

Answer options

• A. Amazon DynamoDB with operations made with the ConsistentRead parameter set to true
• B. Amazon ElastiCache for Memcached with operations made within a transaction block
• C. Amazon DynamoDB with reads and writes made by using Transact* operations
• D. Amazon Aurora MySQL with operations made within a transaction block
• E. Amazon Athena with operations made within a transaction block

Correct answer: C, D

Explanation

Amazon DynamoDB supports ACID transactions across multiple items using Transact* operations, ensuring all-or-nothing execution. Amazon Aurora MySQL is a relational database that natively supports standard SQL transaction blocks with rollback capabilities. Amazon ElastiCache for Memcached, Amazon Athena, and DynamoDB's ConsistentRead parameter do not provide multi-record transactional rollback features.