DBS-C01 · Question #362
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…
The correct answer is A. Establish an AWS Direct Connect hosted connection between the company's data center and C. Use AWS Database Migration Service (AWS DMS) to migrate the on-premises SQL Server E. Grant system-level access to the third-party backup product to perform backups of the Amazon. To migrate a large, high-performance SQL Server Always On cluster to AWS with minimal downtime and support for a third-party backup tool, use AWS Direct Connect, AWS DMS, and ensure system-level access is granted on the EC2-based SQL Server target.
Question
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.)
Options
- AEstablish an AWS Direct Connect hosted connection between the company's data center and
- BCreate an AWS Site-to-Site VPN connection between the company's data center and AWS over
- CUse AWS Database Migration Service (AWS DMS) to migrate the on-premises SQL Server
- DDeploy a new SQL Server Always On availability group DB cluster on Amazon EC2. Configure
- EGrant system-level access to the third-party backup product to perform backups of the Amazon
- FConfigure the third-party backup product to perform backups of the DB cluster on Amazon EC2.
How the community answered
(42 responses)- A64% (27)
- B5% (2)
- D10% (4)
- F21% (9)
Why each option
To migrate a large, high-performance SQL Server Always On cluster to AWS with minimal downtime and support for a third-party backup tool, use AWS Direct Connect, AWS DMS, and ensure system-level access is granted on the EC2-based SQL Server target.
An AWS Direct Connect hosted connection is crucial for ensuring the required 2 Gbps bandwidth and stable, low-latency network connectivity between the on-premises data center and AWS, which is essential for sustaining SQL Server Always On asynchronous data replication and minimizing downtime during migration.
An AWS Site-to-Site VPN connection, while providing connectivity, typically operates over the public internet and cannot reliably guarantee the sustained 2 Gbps bandwidth or the consistent low latency required for high-performance Always On replication during a migration of this scale.
AWS Database Migration Service (DMS) is the appropriate tool for migrating large, high-performance SQL Server databases with minimal downtime and data loss, as it supports continuous data replication (Change Data Capture) from the on-premises source to the AWS target.
Deploying an Always On Availability Group on Amazon EC2 is the correct target architecture to allow system-level access, but it is a prerequisite deployment step rather than a direct migration action related to connectivity, migration tool, or access granting.
Since the third-party backup product requires system-level access and will continue to be used, granting this specific access to the product on the Amazon EC2-based SQL Server deployment is a necessary action to meet the company's ongoing operational requirements.
Configuring the third-party backup product is a subsequent operational step after migration; the more fundamental action related to meeting the requirement is granting the necessary system-level access (E) that enables such configuration.
Concept tested: Hybrid cloud migration strategy for SQL Server Always On with specific requirements (Direct Connect, DMS, system-level access)
Source: https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html
Topics
Community Discussion
No community discussion yet for this question.