A company's enterprise application runs on AWS and uses an Amazon RDS for SQL Server database to store transactional data. The database must be designed to withstand an Availability Zone outage in the primary AWS Region with automatic failover to minimize downtime. Furthermore, the company requires a disaster recovery strategy to support recovery in a secondary AWS Region with a Recovery Point Objective (RPO) of less than 30 minutes.
Which two database configurations should the solutions architect select to meet these requirements? (Select two.)
- Configure the RDS for SQL Server database with a Multi-AZ deployment.Cevap
- Create a cross-region read replica of the RDS for SQL Server database in the secondary AWS Region.Cevap
- CDeploy an RDS for SQL Server read replica in a different Availability Zone within the primary AWS Region to serve as the failover target.
- DImplement Route 53 latency-based routing to automatically redirect application write operations to the secondary region database during an outage.
- EEstablish a pilot light environment by restoring hourly manual snapshots of the database to a secondary region DB instance.
Cevap
The correct configurations are configuring the database with a Multi-AZ deployment and creating a cross-region read replica in the secondary region.
The correct options are configuring the RDS database as a Multi-AZ deployment and creating a cross-region read replica. Multi-AZ replication is synchronous and provides automatic failover within the primary region, securing high availability. A cross-region read replica replicates data asynchronously to the secondary region, keeping the recovery point well within the 30-minute requirement and offering a promotable primary target for disaster recovery.
Adım Adım Çözüm
Anahtar Kavram
Multi-AZ and Cross-Region replication configurations for relational database resilience.