SAA-C03 · Question #785
A company is preparing to migrate its on-premises application to AWS. The application consists of application servers and a Microsoft SQL Server database. The company cannot migrate the database to…
The correct answer is C. Migrate the data to Amazon RDS for SQL Server in a Multi-AZ deployment. Amazon RDS for SQL Server in a Multi-AZ deployment provides high availability with automated failover, backups, and patching, minimizing operational overhead. This allows the company to continue using SQL Server features required by the application without managing the database…
Question
A company is preparing to migrate its on-premises application to AWS. The application consists of application servers and a Microsoft SQL Server database. The company cannot migrate the database to a different engine because SQL Server features are used in the application’s .NET code. The company wants to maximize availability and minimize operational overhead. What should a solutions architect do to meet these requirements?
Options
- AInstall SQL Server on Amazon EC2 in a Multi-AZ deployment.
- BInstall SQL Server on Amazon EC2 in a spread placement group.
- CMigrate the data to Amazon RDS for SQL Server in a Multi-AZ deployment.
- DMigrate the data to Amazon RDS for SQL Server in a cross-Region Multi-AZ deployment.
How the community answered
(28 responses)- A7% (2)
- B4% (1)
- C86% (24)
- D4% (1)
Explanation
Amazon RDS for SQL Server in a Multi-AZ deployment provides high availability with automated failover, backups, and patching, minimizing operational overhead. This allows the company to continue using SQL Server features required by the application without managing the database infrastructure manually.
Community Discussion
No community discussion yet for this question.