AWS Certified Database – Specialty — Question 270

A global company is creating an application. The application must be highly available. The company requires an RTO and an RPO of less than 5 minutes. The company needs a database that will provide the ability to set up an active-active configuration and near real-time synchronization of data across tables in multiple AWS Regions.

Which solution will meet these requirements?

Answer options

• A. Amazon RDS for MariaDB with cross-Region read replicas
• B. Amazon RDS with a Multi-AZ deployment
• C. Amazon DynamoDB global tables
• D. Amazon DynamoDB with a global secondary index (GSI)

Correct answer: C

Explanation

Amazon DynamoDB global tables provide a fully managed, active-active, multi-Region database solution that replicates data near-instantaneously, easily meeting the sub-5-minute RTO and RPO requirements. Amazon RDS options do not support active-active write configurations across multiple regions out of the box. A Global Secondary Index (GSI) helps with query performance on alternative keys but does not enable multi-Region active-active replication.