ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 298 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 298
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A global company needs to migrate from an on-premises Microsoft SQL Server database to a highly available database solution on AWS. The company wants to modernize its application and keep operational costs low. The current database includes secondary indexes and stored procedures that need to be included in the migration. The company has limited availability of database specialists to support the migration and wants to automate the process.

Which solution will meet these requirements?

  • A. Use AWS Database Migration Service (AWS DMS) to migrate all database objects from the on-premises SQL Server database to a Multi-AZ deployment of Amazon Aurora MySQL.
  • B. Use AWS Database Migration Service (AWS DMS) and the AWS Schema Conversion Tool (AWS SCT) to migrate all database objects from the on-premises SQL Server database to a Multi-AZ deployment of Amazon Aurora MySQL.
  • C. Rehost the on-premises SQL Server as a SQL Server Always On availability group. Host members of the availability group on Amazon EC2 instances. Use AWS Database Migration Service (AWS DMS) to migrate all database objects.
  • D. Rehost the on-premises SQL Server as a SQL Server Always On availability group. Host members of the availability group on Amazon EC2 instances in a single subnet that extends across multiple Availability Zones. Use SQL Server tools to migrate the data.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by rdiaz at March 26, 2023, 5:01 p.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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Windy
2 years, 1 month ago
It's B
upvoted 1 times
...
Kodoma
2 years, 2 months ago
Selected Answer: B
B is right.
upvoted 2 times
...
aviathor
2 years, 2 months ago
A. Aurora certainly hits the spot wrt modernisation... but what about secondary objects? B. This takes care of secondary objects C. Rehosting is not "modernisation" D. Rehosting is not "modernisation"
upvoted 2 times
...
tsk9921
2 years, 3 months ago
B is right, heterogeneous migration > SCT + DMS
upvoted 1 times
...
backbencher2022
2 years, 4 months ago
Selected Answer: B
Option B. Since it is a heterogeneous migration we need both DMS and SCT to perform this migration and option B has both components. https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-a-microsoft-sql-server-database-to-aurora-mysql-by-using-aws-dms-and-aws-sct.html
upvoted 1 times
...
rdiaz
2 years, 4 months ago
Selected Answer: B
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-a-microsoft-sql-server-database-to-aurora-mysql-by-using-aws-dms-and-aws-sct.html
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel