A company is developing a business-critical application. Their RTO and RPO requirements call for a relational database in an active-active configuration, with zero downtime for all database operations. What is the optimal database choice for these requirements?

Answer options:

A.Amazon Aurora Global Database
B.Amazon DynamoDB with global tables
C.Amazon Aurora Multi-Master Cluster
D.Amazon RDS with Multi-AZ

Answer: C
Option A is incorrect because Amazon Aurora Global Database uses a primary instance for write operations. Although there is automatic fail-over capability, it is not without any downtime.
Option B is incorrect because the requirement specifically calls for a relational database.
Option C is CORRECT because the Amazon Aurora Multi-Master cluster offers write capability to multiple instances. In applications where zero downtime is required for database write operations, a multi-master cluster can be used to avoid an outage when a writer instance becomes unavailable.
Option D is incorrect because Amazon RDS with Multi-AZ does not meet the requirements. This capability can be used for automatic failover.However, the Multi-AZ instances are not accessible during normal operation.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-multi-master.html