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.)

Topic #: - All AWS Certified Database - Specialty Questions

A. Establish an AWS Direct Connect hosted connection between the company’s data center and AWS.
B. Create an AWS Site-to-Site VPN connection between the company’s data center and AWS over the internet.
C. 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.
D. 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.
E. Grant system-level access to the third-party backup product to perform backups of the Amazon RDS for SQL Server DB instance.
F. Configure the third-party backup product to perform backups of the DB cluster on Amazon EC2.

- Awsexamhub website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Suggested Answer:

Share this post

Join the Discussion