AWS Certified Database – Specialty — Question 309

A company has a 4 ׀¢׀’ on-premises Oracle Real Application Clusters (RAC) database. The company wants to migrate the database to AWS and reduce licensing costs. The company's application team wants to store JSON payloads that expire after 28 hours. The company has development capacity if code changes are required.
Which solution meets these requirements?

Answer options

• A. Use Amazon DynamoDB and leverage the Time to Live (TTL) feature to automatically expire the data.
• B. Use Amazon RDS for Oracle with Multi-AZ. Create an AWS Lambda function to purge the expired data. Schedule the Lambda function to run daily using Amazon EventBridge.
• C. Use Amazon DocumentDB with a read replica in a different Availability Zone. Use DocumentDB change streams to expire the data.
• D. Use Amazon Aurora PostgreSQL with Multi-AZ and leverage the Time to Live (TTL) feature to automatically expire the data.

Correct answer: A

Explanation

Amazon DynamoDB is a fully managed NoSQL database that natively supports JSON payloads and includes a built-in Time to Live (TTL) feature to automatically delete expired items without additional code or cost. Moving from Oracle RAC to DynamoDB successfully reduces licensing costs, which aligns with the company's development capacity to make code adjustments. Other options either retain expensive Oracle licensing (Amazon RDS for Oracle) or propose native features like TTL that do not exist natively in Amazon Aurora PostgreSQL.