A company uses Amazon RDS for Microsoft SQL Server as its primary database.

Amazon Web Services DOP-C02 Question Answer

A company uses Amazon RDS for Microsoft SQL Server as its primary database. They need high availability within and across AWS Regions, with an RPO <1 min and RTO <10 min. Route 53 CNAME is used for the DB endpoint and must redirect to standby during failover.

Which solution meets these requirements?

Deploy an Amazon RDS for SQL Server Multi-AZ DB cluster with cross-Region read replicas. Use automation to promote replica and update Route 53.

Deploy RDS Multi-AZ with snapshots copied every 5 minutes; use Lambda to restore snapshot and update Route 53 on failover.

Deploy Single-AZ RDS and use AWS DMS to continuously replicate to another Region. Use CloudWatch alarms for failover notification.

Deploy Single-AZ RDS and use AWS Backup for cross-Region backups every 30 seconds. Use automation to restore and update Route 53 during failover.

Amazon Web Services DOP-C02 View All Questions

Amazon Web Services DOP-C02 Summary

Vendor: Amazon Web Services
Product: DOP-C02
Update on: Mar 21, 2026
Questions: 425

Price: $52.5 ~~$149.99~~

Buy Now DOP-C02 PDF + Testing Engine Pack

A software engineering team is using AWS CodeDeploy to deploy a new version of an...

A DevOps engineer has automated a web service deployment by using AWS CodePipeline with the...

Spring Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmasmnth

A company uses Amazon RDS for Microsoft SQL Server as its primary database.

The Answer Is:

Explanation:

Amazon Web Services DOP-C02 Summary

Payments We Accept

Contact Us