Exam AWS Certified Database - Specialty topic 1 question 107 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 107
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company is migrating a mission-critical 2-TB Oracle database from on premises to Amazon Aurora. The cost for the database migration must be kept to a minimum, and both the on-premises Oracle database and the Aurora DB cluster must remain open for write traffic until the company is ready to completely cut over to Aurora.
Which combination of actions should a database specialist take to accomplish this migration as quickly as possible? (Choose two.)

A. Use the AWS Schema Conversion Tool (AWS SCT) to convert the source database schema. Then restore the converted schema to the target Aurora DB cluster.
B. Use Oracle's Data Pump tool to export a copy of the source database schema and manually edit the schema in a text editor to make it compatible with Aurora.
C. Create an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster. Select the migration type to replicate ongoing changes to keep the source and target databases in sync until the company is ready to move all user traffic to the Aurora DB cluster.
D. Create an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster. Once the initial load is complete, create an AWS Kinesis Data Firehose stream to perform change data capture (CDC) until the company is ready to move all user traffic to the Aurora DB cluster.
E. Create an AWS Glue job and related resources to migrate data from the Oracle database to the Aurora DB cluster. Once the initial load is complete, create an AWS DMS task to perform change data capture (CDC) until the company is ready to move all user traffic to the Aurora DB cluster.

Show Suggested Answer

Suggested Answer: AC 🗳️

by Jaypdv at April 4, 2021, 6:55 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

Jaypdv

Highly Voted 3 years, 10 months ago

AC. Answer

upvoted 13 times

...

Suresh108

Highly Voted 3 years, 10 months ago

AC --- locked A - OK B - NOT OK Text editor C - ok though it doesn't talk about full load D- NOT ok firehose E - not ok Glue

upvoted 6 times

guru_ji

3 years, 10 months ago

I agree with you.

upvoted 1 times

...

Pranava_GCP

Most Recent 1 year, 11 months ago

Selected Answer: AC

AC are correct answer SCT + DMS

upvoted 2 times

...

FooBarBazBazinga

2 years, 3 months ago

Selected Answer: AC

AC. asnwer

upvoted 1 times

...

backbencher2022

2 years, 5 months ago

Selected Answer: AC

A&C for sure

upvoted 1 times

...

ninjalight25

2 years, 5 months ago

Selected Answer: AC

AC --- locked

upvoted 1 times

...

novice_expert

3 years, 3 months ago

Selected Answer: AC

A. Use the AWS Schema Conversion Tool (AWS SCT) to convert the source database schema. Then restore the converted schema to the target Aurora DB cluster. x B. edit C. Create an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster. Select the migration type to replicate ongoing changes to keep the source and target databases in sync until the company is ready to move all user traffic to the Aurora DB cluster. x D. kinesis firehose x E. Glue job

upvoted 2 times

...