Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 10 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 10
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle
DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region.
Where should the AWS DMS replication instance be placed for the MOST optimal performance?

A. In the same Region and VPC of the source DB instance
B. In the same Region and VPC as the target DB instance
C. In the same VPC and Availability Zone as the target DB instance
D. In the same VPC and Availability Zone as the source DB instance

Show Suggested Answer

Suggested Answer: C 🗳️

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

zanhsieh

Highly Voted 3 years, 9 months ago

C. See the diagram here: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.VPC.html#CHAP_ReplicationInstance.VPC.Configurations.ScenarioVPCPeer In fact, all the configurations list on above url prefer the replication instance putting into target vpc region / subnet / az.

upvoted 17 times

scottkerker

3 years, 6 months ago

There is also another question related to migration between a RDS resource and a Redshift cluster where they are in different VPCs and the Redshift cluster is the target. It asks readers where should the DMS replication instance be placed and the answer is the replication instance should be placed with the same VPC as the target.

upvoted 2 times

...

halol

Highly Voted 3 years, 9 months ago

D is correct based on : https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.html it shows Choose the Availability Zone where your source database is located.

upvoted 6 times

BillyMadison

3 years, 9 months ago

Going with D as well since it mentions in your link "reducing load on your source database"

upvoted 1 times

BillyMadison

3 years, 8 months ago

Changing my mind and going with C now. Talked with an AWS solutions architect. He said "target DB instance" has worked better for him in the past.

upvoted 5 times

...

guru_ji

3 years, 8 months ago

C is correct. glat mtt kar dena exam mein. All the Best !!

upvoted 1 times

...

michalf84

Most Recent 8 months, 1 week ago

Selected Answer: B

B there is similar question for redshift migration. You want to reduce latency

upvoted 1 times

...

MultiAZ

1 year, 5 months ago

Selected Answer: C

It is C - same VPC and AZ as the target.

upvoted 1 times

...

blah88

1 year, 9 months ago

Selected Answer: B

Answer is B. In the network configuration for database migrations section on this page https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.VPC.html States --> When practical, we recommend that you create a DMS replication instance in the same Region as your target endpoint, and in the same VPC or subnet as your target endpoint.

upvoted 1 times

...

Pranava_GCP

1 year, 9 months ago

Selected Answer: C

C. In the same VPC and Availability Zone as the target DB instance

upvoted 1 times

...

aws2023a

1 year, 10 months ago

https://repost.aws/questions/QUUUL_7NsZS8OBI_GkCRSRRg/why-place-dms-replication-instance-in-target-vpc-instead-of-source-vpc

upvoted 2 times

...

leotoras

1 year, 11 months ago

D is the right answer. It is a heterogeneous migration, some data transformations need to be performed before loading in the target. That's why it should be in the source database VPC.

upvoted 1 times

...

f___16

2 years, 3 months ago

Selected Answer: C

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.VPC.html#CHAP_ReplicationInstance.VPC.Configurations.ScenarioVPCPeer

upvoted 1 times

...

Vgarg2091

2 years, 4 months ago

Ans C : Generally, you’d get better performance by placing primary DMS replication instance is in the same AZ as the target DB

upvoted 1 times

...

lollyj

2 years, 6 months ago

Selected Answer: C

Answer: C. I'm new to this site. Is the suggested answer typically the correct answer. I'm really confused. Who provides the suggested answers on this site?

upvoted 2 times

Zdujgfr567783ff

2 years, 2 months ago

just a dummy random answer

upvoted 2 times

...

novice_expert

3 years, 1 month ago

Selected Answer: C

C. In the same VPC and Availability Zone as the target DB instance (BTW, target region is implicit) https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.VPC.html#CHAP_ReplicationInstance.VPC.Configurations.ScenarioVPCPeer

upvoted 3 times

...

jnassp1

3 years, 8 months ago

C - "For best results, we recommend that you locate your replication instance in the same VPC and Availability Zone as your target database, in this case Aurora MySQL." -

upvoted 2 times

...

Anuragdba

3 years, 8 months ago

C: we will get performance improvement if place dms replication instance in target (VPC & availability zone same )

upvoted 1 times

...

LB

3 years, 8 months ago

C is the right answer here ie, the DMS replication instance should be placed in the target AZ. D would have been correct if the source data needed a lot of filtering and manipulation before transferring data to the target.

upvoted 2 times

Paulv82003

2 years ago

But data will needed a lot of filtering and manipulation before transferring data to the target going from Oracle to PostgreSQL, D is the correct answer

upvoted 1 times

...

aws4myself

3 years, 8 months ago

C => AZ of target instance

upvoted 1 times

...

guru_ji

3 years, 8 months ago

C ==>> Correct Answer

upvoted 1 times

...

Load full discussion...