Which solution will meet these requirements?

By:
In: DBS-C01
Tagged:
With: 1 Comment
A company is running a business-critical application on premises by using Microsoft SQL Server.A database specialist is planning to migrate the instance with several databases to the AWS Cloud.The database specialist will use SQL Server Standard edition hosted on Amazon EC2 Windows instances.The solution must provide high availability and must avoid a single point of failure in the SQL Server deployment architecture.

Which solution will meet these requirements?

Create Amazon RDS for SQL Server Multi-AZ DB instances. Use Amazon S3 as a shared storage option to host the databases.

Set up Always On Failover Cluster Instances as a single SQL Server instance. Use Multi-AZ Amazon FSx for Windows File Server as a shared storage option to host the databases.

Set up Always On availability groups to group one or more user databases that fail over together across multiple SQL Server instances. Use Multi-AZ Amazon FSx for Windows File Server as a shared storage option to host the databases.

Create an Application Load Balancer to distribute database traffic across multiple EC2 instances in multiple Availability Zones. Use Amazon S3 as a shared storage option to host the databases.

2025-10-10

1 Comment

  1. Jessica
    Author

    I evaluate that the answer is:
    Set up Always On Failover Cluster Instances as a single SQL Server instance. Use Multi-AZ Amazon FSx for Windows File Server as a shared storage option to host the databases.

Leave a Reply

Your email address will not be published. Required fields are marked *

one × 2 =