AWS Certified Solutions Architect Professional SAP-C02 Practice Question

The correct answer is to deploy Amazon Aurora PostgreSQL-Compatible Edition as a global database. This solution meets all the specified requirements. Amazon Aurora Global Database is designed for globally distributed applications and provides a robust disaster recovery solution. It supports cross-region replication with typical latencies of less than one second, which satisfies the RPO requirement. In the event of a regional outage, a secondary region can be promoted to full read/write capabilities in under a minute, meeting the strict RTO requirement. As a PostgreSQL-compatible, fully managed service, it eliminates SQL Server licensing costs and reduces operational overhead. Furthermore, Aurora PostgreSQL supports the PostGIS extension, which is necessary for handling the existing application's spatial data queries.

Deploying Amazon RDS for PostgreSQL with a cross-region read replica is incorrect because promoting a read replica to a standalone primary instance is a manual process that takes longer than the required one-minute RTO. While it is a valid DR strategy, it is not suitable for such aggressive recovery objectives.

Deploying self-managed SQL Server Enterprise on EC2 instances is incorrect because it fails to meet the key business goals of reducing licensing costs and minimizing operational overhead. This approach would require continued payment for expensive SQL Server Enterprise licenses and would entail a significant management burden for the infrastructure and database software.

Deploying Amazon DynamoDB with Global Tables and Amazon Redshift is incorrect for several reasons. Firstly, it disregards the stated preference for a PostgreSQL-compatible solution. Secondly, migrating from a relational model with complex spatial queries to a NoSQL/data warehouse model would require a significant and costly re-architecture of the application, not just a database migration.