Exam AWS Certified Solutions Architect - Professional All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional exam

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

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

Question #: 513
Topic #: 1

[All AWS Certified Solutions Architect - Professional Questions]

A company is planning to migrate an application from on-premises to AWS. The application currently uses an Oracle database and the company can tolerate a brief downtime of 1 hour when performing the switch to the new infrastructure. As part of the migration, the database engine will be changed to MySQL. A
Solutions Architect needs to determine which AWS services can be used to perform the migration while minimizing the amount of work and time required.
Which of the following will meet the requirements?

A. Use AWS SCT to generate the schema scripts and apply them on the target prior to migration. Use AWS DMS to analyze the current schema and provide a recommendation for the optimal database engine. Then, use AWS DMS to migrate to the recommended engine. Use AWS SCT to identify what embedded SQL code in the application can be converted and what has to be done manually.
B. Use AWS SCT to generate the schema scripts and apply them on the target prior to migration. Use AWS DMS to begin moving data from the on-premises database to AWS. After the initial copy, continue to use AWS DMS to keep the databases in sync until cutting over to the new database. Use AWS SCT to identify what embedded SQL code in the application can be converted and what has to be done manually.
C. Use AWS DMS to help identify the best target deployment between installing the database engine on Amazon EC2 directly or moving to Amazon RDS. Then, use AWS DMS to migrate to the platform. Use AWS Application Discovery Service to identify what embedded SQL code in the application can be converted and what has to be done manually.
D. Use AWS DMS to begin moving data from the on-premises database to AWS. After the initial copy, continue to use AWS DMS to keep the databases in sync until cutting over to the new database. Use AWS Application Discovery Service to identify what embedded SQL code in the application can be converted and what has to be done manually.

Show Suggested Answer

Suggested Answer: B 🗳️

by huhupai at Sept. 14, 2019, 3:09 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

Submit Cancel

donathon

Highly Voted 3 years, 8 months ago

B A: Need to minimize work and time required. MySQL has already been chosen why do we need to provide recommendation? C\D: SCT needs to be used.

upvoted 22 times

sam422

3 years, 7 months ago

To move an instance to a placement group using the AWS CLI Stop the instance using the stop-instances command. Use the modify-instance-placement command and specify the name of the placement group to which to move the instance. aws ec2 modify-instance-placement --instance-id i-0123a456700123456 --group-name MySpreadGroup Start the instance using the start-instances command.

upvoted 1 times

...

huhupai

Highly Voted 3 years, 8 months ago

AWS Application Discovery Service can't identify what embedded SQL code in the application, SCT can scan application source code for embedded SQL statements and convert them as part of a database schema conversion project. So I think the correct answer is B.

upvoted 12 times

dpvnme

3 years, 8 months ago

Bbbbbbb

upvoted 5 times

...

SkyZeroZx

Most Recent 1 year, 11 months ago

Selected Answer: B

B A: Need to minimize work and time required. MySQL has already been chosen why do we need to provide recommendation? C\D: SCT needs to be used.

upvoted 1 times

...

andras

2 years, 3 months ago

https://docs.amazonaws.cn/en_us/dms/latest/userguide/CHAP_SchemaConversion.html It seems Schema conversion could be solved with DMS. Why do we need separate SCT???

upvoted 1 times

...

cldy

3 years, 5 months ago

B. Use AWS SCT to generate the schema scripts and apply them on the target prior to migration. Use AWS DMS to begin moving data from the on-premises database to AWS. After the initial copy, continue to use AWS DMS to keep the databases in sync until cutting over to the new database. Use AWS SCT to identify what embedded SQL code in the application can be converted and what has to be done manually.

upvoted 1 times

...

AzureDP900

3 years, 5 months ago

I agree with B

upvoted 2 times

...

WhyIronMan

3 years, 6 months ago

I'll go with B

upvoted 2 times

...

Waiweng

3 years, 6 months ago

It's B

upvoted 2 times

...

Kelvin

3 years, 7 months ago

BBBBBBBBBB

upvoted 1 times

...

Kian1

3 years, 7 months ago

going with B

upvoted 2 times

...

Ebi

3 years, 7 months ago

Answer is B

upvoted 4 times

...

rkbala

3 years, 7 months ago

B is the correct answer

upvoted 2 times

...

Bulti

3 years, 7 months ago

Answer is B not A as it doesn't seem to meet the 1 hour downtime req

upvoted 1 times

...

petebear55

3 years, 7 months ago

This is a typical example of how aws tries to trip u up in the exam .. using terms like SCT instead of the full The AWS Schema Conversion Tool (AWS SCT) which helps convert your existing database schema from one database engine to another. You can convert from a relational OLTP schema or any supported data warehouse OLAP schema to Amazon RDS (for example, Amazon Aurora MySQL or Amazon Aurora PostgreSQL, among others).

upvoted 1 times

...