A company runs web servers using an Amazon RDS for PostgreSQL DB instance. A compliance standard requires a recovery point objective (RPO) of under 1 second for all production databases. Which solution meets this requirement?

Enabling a Multi-AZ deployment for an Amazon RDS for PostgreSQL DB instance provides synchronous replication to a standby instance in a different Availability Zone. This ensures that all data changes are written to both the primary and standby instances before being committed, resulting in an RPO of effectively zero (under 1 second). If the primary instance fails, Amazon RDS automatically fails over to the standby, minimizing data loss. Enabling auto scaling for a single-AZ instance does not address RPO as it only scales resources, not data redundancy. Configuring read replicas in a separate AZ provides asynchronous replication, meaning there's a replication lag, and thus an RPO greater than 1 second. AWS DMS CDC tasks also involve asynchronous replication and potential latency, making them unsuitable for an RPO of under 1 second.