QuestionQ17

VerifiedResilient Cloud Solutions

A company uses Amazon RDS for Microsoft SQL Server as the primary database for its applications. The company must provide high availability both within AWS Regions and across AWS Regions.

An Amazon Route 53 CNAME record is configured for the database endpoint, and the applications connect through that endpoint. During a failover event, the company must redirect application traffic to a standby database. The company must maintain an RPO of less than 1 minute and an RTO of less than 10 minutes.

Which solution meets these requirements?

Explanation

A pre-created cross-Region read replica provides a continuously replicated recovery database that can be promoted to a standalone DB instance during a regional failure. Automation can update the Route 53 CNAME after promotion, while a Multi-AZ deployment provides high availability within the primary Region. Snapshot-based recovery is too infrequent or too slow for the stated recovery objectives, and DMS replication with notifications alone does not perform the required database promotion and traffic cutover. Cross-Region read replicas for RDS SQL Server require an eligible SQL Server Enterprise Edition version.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!