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 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 Hide 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

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
chicagomassageseeker
Highly Voted 3 years, 7 months ago
Answer C. This is heterogenous migration and requires DMS and SCT.
upvoted 17 times
...
learnaws
Highly Voted 3 years, 7 months ago
Yep, C here
upvoted 6 times
BillyMadison
3 years, 7 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, 3 months ago
Selected Answer: C
Answer C. This is heterogenous migration and requires DMS and SCT.
upvoted 1 times
...
examineme
2 years, 5 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, 6 months ago
Answer: C https://docs.aws.amazon.com/dms/latest/sbs/chap-on-premoracle2aurora.html
upvoted 2 times
...
novice_expert
3 years 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
...
LMax
3 years, 6 months ago
Answer C should be the one.
upvoted 2 times
...
myutran
3 years, 6 months ago
Ans: C
upvoted 1 times
...
JobinAkaJoe
3 years, 7 months ago
C is the right choice
upvoted 1 times
...
Ashoks
3 years, 7 months ago
Yes, it is C. Zero down time = First SCT and then DMS full and CDC
upvoted 2 times
...
Mickysingh
3 years, 7 months ago
Ans D can not be right as it is not doing schema conversion and using oracle backup for restoring. Also downtime is high.
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago