AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A company wants to use the AWS Cloud to improve its on-premises disaster recovery (DR) configuration. The company's core production business application uses Microsoft SQL Server Standard, which runs on a virtual machine (VM). The application has a recovery point objective (RPO) of 30 seconds or fewer and a recovery time objective (RTO) of 60 minutes. The DR solution needs to minimize costs wherever possible.
Which solution will meet these requirements?
Other
Community
UAnonymous
A
Configure a multi-site active/active setup between the on-premises server and AWS by using Microsoft SQL Server Enterprise with Always On availability groups.
B
Configure a warm standby Amazon RDS for SQL Server database on AWS. Configure AWS Database Migration Service (AWS DMS) to use change data capture (CDC).
C
Use AWS Elastic Disaster Recovery configured to replicate disk changes to AWS as a pilot light.
D
Use third-party backup software to capture backups every night. Store a secondary set of backups in Amazon S3.
Explanation:
Explanation
Why Option C is correct:
AWS Elastic Disaster Recovery (formerly CloudEndure Disaster Recovery) is specifically designed for disaster recovery scenarios with tight RPO and RTO requirements. Here's why it meets all the requirements:
-
RPO of 30 seconds or fewer: AWS Elastic Disaster Recovery continuously replicates block-level changes from the source VM to AWS, achieving near-continuous data replication with minimal RPO.
-
RTO of 60 minutes: The solution can quickly spin up replicated instances in AWS, meeting the 60-minute RTO requirement.
-
Cost minimization: The "pilot light" configuration keeps minimal resources running in AWS (just enough to maintain the replicated data), significantly reducing costs compared to maintaining a fully operational standby environment.
-
Microsoft SQL Server Standard compatibility: AWS Elastic Disaster Recovery replicates the entire VM, including the SQL Server installation, without requiring an upgrade to Enterprise edition.
Why other options are incorrect:
Option A: Requires upgrading to SQL Server Enterprise edition, which increases costs. Multi-site active/active is also more expensive than needed for DR purposes.
Option B: While AWS DMS with CDC can achieve low RPO, it requires maintaining a warm standby RDS instance, which is more expensive than a pilot light configuration. Also, RDS licensing costs may be higher.
Option D: Nightly backups cannot meet the 30-second RPO requirement. This approach would result in significant data loss (up to 24 hours) in a disaster scenario.
Key AWS services mentioned:
- AWS Elastic Disaster Recovery: Continuous replication service for disaster recovery
- Pilot light configuration: Minimal standby resources to reduce costs
- RPO (Recovery Point Objective): Maximum acceptable data loss
- RTO (Recovery Time Objective): Maximum acceptable downtime
Comments
Loading comments...