nerdexam
AmazonAmazon

DOP-C02 · Question #410

DOP-C02 Question #410: Real Exam Question with Answer & Explanation

The correct answer is A: Deploy an Amazon RDS for SQL Server Multi-AZ DB cluster deployment that uses cross-Region. Deploying a Multi-AZ DB cluster with cross-Region read replicas ensures high availability both within and across AWS Regions. Automation can promote a read replica during failover and update the Route 53 CNAME record for application traffic redirection. This approach meets the re

Submitted by haru.x· Mar 6, 2026Reliability & Resilience

Question

A company uses Amazon RDS for Microsoft SQL Server as its primary database for applications. The company needs to ensure high availability within and across AWS Regions. An Amazon Route 53 CNAME record is configured for the database endpoint. The applications connect to the database endpoint. The company must redirect application traffic to a standby database during a failover event. The company must maintain an RPO of less than 1 minute and an RTO of less than 10 minutes. Which solution will meet these requirements?

Options

  • ADeploy an Amazon RDS for SQL Server Multi-AZ DB cluster deployment that uses cross-Region
  • BDeploy an Amazon RDS for SQL Server Multi-AZ DB cluster deployment. Set up automated
  • CDeploy an Amazon RDS for SQL Server Single-AZ DB instance. Use AWS Database Migration
  • DDeploy an Amazon RDS for SQL Server Single-AZ DB instance. Configure AWS Backup to

Explanation

Deploying a Multi-AZ DB cluster with cross-Region read replicas ensures high availability both within and across AWS Regions. Automation can promote a read replica during failover and update the Route 53 CNAME record for application traffic redirection. This approach meets the required RPO of less than 1 minute and RTO of less than 10 minutes.

Topics

#RDS SQL Server#Multi-AZ#cross-Region DR#RPO/RTO

Community Discussion

No community discussion yet for this question.

Full DOP-C02 PracticeBrowse All DOP-C02 Questions