Question

A financial services company is deploying a transactional database in a public cloud. The application requires an RTO of under 60 seconds and cannot tolerate data loss during an availability zone outage. The database must remain writable at all times. Which design best meets these requirements?

Accepted Answer

Deploy a primary database with a synchronous standby replica in a second availability zone and automatic failover

Answer

Deploy a single database instance with automated daily snapshots stored in a separate region

Answer

Deploy a primary database with multiple asynchronous read replicas in the same availability zone

Answer

Deploy the database on a serverless platform that scales to zero during periods of inactivity