DVA-C02 · Question #574
An ecommerce company is planning to migrate an on-premises Microsoft SQL Server database to the AWS Cloud. The company needs to migrate the database to SQL Server Always On availability groups. The…
The correct answer is C. Deploy three Amazon EC2 instances with SQL Server across three Availability Zones. Use. SQL Server Always On availability groups require a shared storage solution. Amazon FSx for Windows File Server provides the shared storage necessary to implement Always On availability groups in a highly available configuration.
Question
An ecommerce company is planning to migrate an on-premises Microsoft SQL Server database to the AWS Cloud. The company needs to migrate the database to SQL Server Always On availability groups. The cloud-based solution must be highly available. Which solution will meet these requirements?
Options
- ADeploy three Amazon EC2 instances with SQL Server across three Availability Zones. Attach one
- BMigrate the database to Amazon RDS for SQL Server. Configure a Multi-AZ deployment and read
- CDeploy three Amazon EC2 instances with SQL Server across three Availability Zones. Use
- DDeploy three Amazon EC2 instances with SQL Server across three Availability Zones. Use
How the community answered
(24 responses)- A4% (1)
- B4% (1)
- C75% (18)
- D17% (4)
Explanation
SQL Server Always On availability groups require a shared storage solution. Amazon FSx for Windows File Server provides the shared storage necessary to implement Always On availability groups in a highly available configuration.
Community Discussion
No community discussion yet for this question.