Q: 20
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 TIE. 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? (Select
THREE.)
Establish an AWS Direct Connect hosted connection between the companfs data center and AWS
Create an AWS Site-to-Site VPN connection between the companVs 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.
Your Answer
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.