Exam AWS Certified Database - Specialty topic 1 question 353 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 353
Topic #: 1

[All AWS Certified Database - Specialty Questions]

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

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.

Show Suggested Answer

Suggested Answer: ADF 🗳️

by fceb2c1 at March 3, 2024, 10:30 a.m.

Disclaimers:

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

Comments

Submit Cancel

tsangckl

1 year, 2 months ago

Selected Answer: ADF

AWS Direct Connect provides a dedicated network connection from your premises to AWS, which can provide more bandwidth throughput and a more consistent network experience than internet-based connections. This would help sustain the 2 Gbps connection needed for Always On asynchronous data replication. Deploying a new SQL Server Always On availability group DB cluster on Amazon EC2 and configuring Always On distributed availability groups between the on-premises DB cluster and the AWS DB cluster would allow for minimal downtime and data loss during migration. The failover to the AWS DB cluster can be done when it is time to migrate. Since the company wants to continue using the third-party backup product, configuring it to perform backups of the DB cluster on Amazon EC2 would meet this requirement. Amazon EC2 instances provide the system-level access required by the third-party backup product.

upvoted 1 times

...

must_be_rohit

1 year, 3 months ago

Selected Answer: ACE

Amazon RDS for SQL server supports Always ON : https://aws.amazon.com/about-aws/whats-new/2018/11/amazon-rds-for-sql-server-now-supports-alwayson-availability-groups/#:~:text=Amazon%20RDS%20for%20SQL%20Server%20now%20offers%20Always%20On%20Availability,production%20workloads%20on%20SQL%20Server.

upvoted 1 times

...

marcoforexam

1 year, 3 months ago

Selected Answer: ADF

it needs ec2

upvoted 3 times

...

fceb2c1

1 year, 4 months ago

Selected Answer: ACE

A. Establish an AWS Direct Connect hosted connection between the company’s data center and AWS. 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. E. Grant system-level access to the third-party backup product to perform backups of the Amazon RDS for SQL Server DB instance.

upvoted 1 times

...