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

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
zanhsieh
Highly Voted 3 years, 6 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, 4 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, 7 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, 7 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, 6 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, 6 months ago
C is correct. glat mtt kar dena exam mein. All the Best !!
upvoted 1 times
...
...
michalf84
Most Recent 6 months ago
Selected Answer: B
B there is similar question for redshift migration. You want to reduce latency
upvoted 1 times
...
MultiAZ
1 year, 3 months ago
Selected Answer: C
It is C - same VPC and AZ as the target.
upvoted 1 times
...
blah88
1 year, 7 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, 7 months ago
Selected Answer: C
C. In the same VPC and Availability Zone as the target DB instance
upvoted 1 times
...
aws2023a
1 year, 8 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, 9 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, 1 month 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, 2 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, 4 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 ago
just a dummy random answer
upvoted 2 times
...
...
novice_expert
2 years, 11 months 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, 5 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, 5 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, 5 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
1 year, 10 months 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, 6 months ago
C => AZ of target instance
upvoted 1 times
...
guru_ji
3 years, 6 months ago
C ==>> Correct Answer
upvoted 1 times
...
Load full discussion...
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