Exam AWS Certified Solutions Architect - Professional topic 1 question 644 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Professional

Question #: 644
Topic #: 1

[All AWS Certified Solutions Architect - Professional Questions]

A company is planning to migrate its business-critical applications from an on-premises data center to AWS. The company has an on-premises installation of a
Microsoft SQL Server Always On cluster. The company wants to migrate to an AWS managed database service. A solutions architect must design a heterogeneous database migration on AWS.
Which solution will meet these requirements?

A. Migrate the SQL Server databases to Amazon RDS for MySQL by using backup and restore utilities.
B. Use an AWS Snowball Edge Storage Optimized device to transfer data to Amazon S3. Set up Amazon RDS for MySQL. Use S3 integration with SQL Server features, such as BULK INSERT.
C. Use the AWS Schema Conversion Tool to translate the database schema to Amazon RDS for MeSQL. Then use AWS Database Migration Service (AWS DMS) to migrate the data from on-premises databases to Amazon RDS.
D. Use AWS DataSync to migrate data over the network between on-premises storage and Amazon S3. Set up Amazon RDS for MySQL. Use S3 integration with SQL Server features, such as BULK INSERT.

Show Suggested Answer

Suggested Answer: A 🗳️
Reference:
https://docs.aws.amazon.com/dms/latest/sbs/dms-sbs-welcome.html

by rootx at Dec. 29, 2021, 8:46 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

Ni_yot

3 years, 4 months ago

c of cause

upvoted 1 times

...

wpinfo

3 years, 5 months ago

Selected Answer: C

answer should be C. The AWS Schema Conversion Tool (AWS SCT) makes heterogeneous database migrations. https://aws.amazon.com/dms/schema-conversion-tool/

upvoted 1 times

...