AWS Certified Data Engineer – Associate (DEA-C01) — Question 109

A company wants to migrate data from an Amazon RDS for PostgreSQL DB instance in the eu-east-1 Region of an AWS account named Account_A. The company will migrate the data to an Amazon Redshift cluster in the eu-west-1 Region of an AWS account named Account_B.

Which solution will give AWS Database Migration Service (AWS DMS) the ability to replicate data between two data stores?

Answer options

• A. Set up an AWS DMS replication instance in Account_B in eu-west-1.
• B. Set up an AWS DMS replication instance in Account_B in eu-east-1.
• C. Set up an AWS DMS replication instance in a new AWS account in eu-west-1.
• D. Set up an AWS DMS replication instance in Account_A in eu-east-1.

Correct answer: A

Explanation

The correct answer is A because setting up the AWS DMS replication instance in Account_B in the same region as the target Amazon Redshift cluster (eu-west-1) ensures efficient data transfer. Options B and D place the replication instance in the source region (eu-east-1), which would complicate the replication process, while option C is unnecessary as it involves creating a new AWS account that adds complexity without benefits.