Exam AWS Certified Database - Specialty topic 1 question 55 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 55
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A Database Specialist needs to define a database migration strategy to migrate an on-premises Oracle database to an Amazon Aurora MySQL DB cluster. The company requires near-zero downtime for the data migration. The solution must also be cost-effective.
Which approach should the Database Specialist take?

A. Dump all the tables from the Oracle database into an Amazon S3 bucket using datapump (expdp). Run data transformations in AWS Glue. Load the data from the S3 bucket to the Aurora DB cluster.
B. Order an AWS Snowball appliance and copy the Oracle backup to the Snowball appliance. Once the Snowball data is delivered to Amazon S3, create a new Aurora DB cluster. Enable the S3 integration to migrate the data directly from Amazon S3 to Amazon RDS.
C. Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during the schema migration. Use AWS DMS to perform the full load and change data capture (CDC) tasks.
D. Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an Amazon EC2 instance. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to an Aurora DB cluster.

Show Suggested Answer

Suggested Answer: C 🗳️

by pan24 at July 9, 2020, 7:56 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

chicagomassageseeker

Highly Voted 3 years, 9 months ago

Answer C. This is heterogenous migration and requires DMS and SCT.

upvoted 17 times

...

learnaws

Highly Voted 3 years, 8 months ago

Yep, C here

upvoted 6 times

BillyMadison

3 years, 8 months ago

Looks correct https://aws.amazon.com/blogs/database/migrating-oracle-databases-with-near-zero-downtime-using-aws-dms/

upvoted 2 times

...

renfdo

Most Recent 2 years, 5 months ago

Selected Answer: C

Answer C. This is heterogenous migration and requires DMS and SCT.

upvoted 1 times

...

examineme

2 years, 7 months ago

Selected Answer: C

Answer is C: Use AWS Schema Conversion Tool to convert Database and DMS for fast transfer.

upvoted 2 times

...

rags1482

2 years, 8 months ago

Answer: C https://docs.aws.amazon.com/dms/latest/sbs/chap-on-premoracle2aurora.html

upvoted 2 times

...

novice_expert

3 years, 2 months ago

Selected Answer: C

https://aws.amazon.com/blogs/database/migrating-oracle-databases-with-near-zero-downtime-using-aws-dms/ Zero down time = First SCT and then DMS full and CDC C. Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during the schema migration. Use AWS DMS to perform the full load and change data capture (CDC) tasks.

upvoted 3 times

...