nerdexam
Amazon

SAP-C02 · Question #120

A company's solution architect is designing a diasaster recovery (DR) solution for an application that runs on AWS. The application uses PostgreSQL 11.7 as its database. The company has an PRO of 30…

The correct answer is C. Migrate the database to an Amazon Aurora PostgreSQL global database with the primary Region. Managed planned failover. To relocate your primary database cluster to one of the secondary Regions in your Aurora global database, see Managed planned failovers with Amazon Aurora Global Database. With this feature, RPO is 0 (no data loss) and it synchronizes secondary DB…

Submitted by wei.xz· Mar 6, 2026Design for New Solutions

Question

A company's solution architect is designing a diasaster recovery (DR) solution for an application that runs on AWS. The application uses PostgreSQL 11.7 as its database. The company has an PRO of 30 seconds. The solutions architect must design a DR solution with the primary database in the us-east-1 Region and the database in the us-west-2 Region. What should the solution architect do to meet these requirements with minimum application change?

Options

  • AMigrate the database to Amazon RDS for PostgreSQL in us-east-1.
  • BMigrate the database to Amazon for PostgreSQL in us-east-1.
  • CMigrate the database to an Amazon Aurora PostgreSQL global database with the primary Region
  • DMigrate the database to Amazon DynamoDB in us-east-1.

How the community answered

(20 responses)
  • B
    10% (2)
  • C
    85% (17)
  • D
    5% (1)

Explanation

Managed planned failover. To relocate your primary database cluster to one of the secondary Regions in your Aurora global database, see Managed planned failovers with Amazon Aurora Global Database. With this feature, RPO is 0 (no data loss) and it synchronizes secondary DB clusters with the primary before making any other changes. RTO for this automated process is typically less than that of the manual failover.

Community Discussion

No community discussion yet for this question.

Full SAP-C02 Practice