Which combination of actions should a database specialist take to meet these requirements?

By:
In: DBS-C01
Tagged:
With: 1 Comment
A company uses a large, growing, and high performance on-premises Microsoft SQL Server instance with an Always On availability group cluster size of 120 TiB.The company uses a third-party backup product that requires system-level access to the databases.The company will continue to use this third-party backup product in the future.The company wants to move the DB cluster to AWS with the least possible downtime and data loss.The company needs a 2 Gbps connection to sustain Always On asynchronous data replication between the company’s data center and AWS.

Which combination of actions should a database specialist take to meet these requirements?

(Choose three.)

Establish an AWS Direct Connect hosted connection between the company’s data center and AWS.

Create an AWS Site-to-Site VPN connection between the company’s data center and AWS over the internet.

Use AWS Database Migration Service (AWS DMS) to migrate the on-premises SQL Server databases to Amazon RDS for SQL Server. Configure Always On availability groups for SQL Server.

Deploy a new SQL Server Always On availability group DB cluster on Amazon EC2. Configure Always On distributed availability groups between the on-premises DB cluster and the AWS DB cluster. Fail over to the AWS DB cluster when it is time to migrate.

Grant system-level access to the third-party backup product to perform backups of the Amazon RDS for SQL Server DB instance.

Configure the third-party backup product to perform backups of the DB cluster on Amazon EC2.

Explanations:

AWS Direct Connect provides a high-bandwidth, low-latency connection, supporting a 2 Gbps requirement for Always On asynchronous replication, ensuring stable data transfer between the on-premises setup and AWS.

AWS Site-to-Site VPN does not guarantee the 2 Gbps bandwidth required for replication and may experience latency over the internet, which is unsuitable for high-performance replication needs.

AWS DMS is not suitable for continuous real-time synchronization for a high-performance Always On availability group. AWS DMS typically performs batch migrations and would not support the required low-downtime migration.

Deploying SQL Server Always On in Amazon EC2 enables the use of distributed availability groups, which allow asynchronous replication to AWS and meet the requirement for high-performance with minimal downtime during migration.

Amazon RDS for SQL Server does not allow system-level access required by the third-party backup product, making it unsuitable for this use case.

The third-party backup product can be configured to access the SQL Server on Amazon EC2, as this setup allows system-level access necessary for backups, meeting the company’s requirements.

2025-10-07

1 Comment

  1. Luke
    Author

    I figure that the answer is:
    Establish an AWS Direct Connect hosted connection between the company’s data center and AWS.

Leave a Reply

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

five × two =