Q11 — AWS SAA-C03 Ch.10

Question 11 of 100 | ← Chapter 10

Q611. 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?

Correct Answer: 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).

Explanation

The solution that will meet the requirements of improving the on-premises disaster recovery configuration for the company's Microsoft SQL Server Standard application, while minimizing costs, is: 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). Explanation: Option B suggests configuring a warm standby Amazon RDS for SQL Server database on AWS and using AWS Database Migration Service (AWS DMS) with change data capture (CDC). Advantages of this solution include: \1. Recovery Point Objective (RPO): By using AWS DMS with change data capture (CDC), the solution can capture and replicate changes made to the on-premises SQL Server database to the Amazon RDS for SQL Server database in near real-time. This helps achieve an RPO of 30 seconds or fewer, as the standby database stays updated with minimal lag. \2. Recovery Time Objective (RTO): The warm standby Amazon RDS for SQL Server database can be pre-configured and kept in sync with the on-premises database. In the event of a disaster, the standby database can be quickly promoted to the primary role, minimizing the recovery time and meeting the RTO of 60 minutes. \3. Minimizing Costs: Using Amazon RDS for SQL Server as a warm standby database eliminates the need to maintain and manage a separate VM on AWS. Amazon RDS simplifies database management tasks and reduces administrative overhead. AWS DMS with change data capture (CDC) allows for efficient and cost-effective replication of database changes. Compared to the other options, option B provides the most suitable and cost-effective solution for meeting the requirements: A. Configuring a multi-site active/active setup with SQL Server Enterprise and Always On availability groups: While this option provides high availability, it may introduce higher licensing costs due to the requirement of SQL Server Enterprise edition. It may also involve more complex configuration and management. C. Using AWS Elastic Disaster Recovery with a pilot light configuration: This option involves replicating disk changes to AWS as a pilot light, which may not be the most efficient or cost-effective solution for a Microsoft SQL Server Standard database. D. Using third-party backup software and storing backups in Amazon S3: This option focuses on backup and storage, rather than meeting the specified RPO and RTO. It may require manual steps for restoration and does not provide near real-time replication. In summary, to improve the company's on-premises disaster recovery configuration for the Microsoft SQL Server Standard application while minimizing costs, the recommended solution is to configure a warm standby Amazon RDS for SQL Server database on AWS and use AWS Database Migration Service (AWS DMS) with change data capture (CDC) (Option B). This solution provides near real-time replication, meets the specified RPO and RTO, and simplifies database management tasks while minimizing costs.