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?
To replicate data from an Amazon RDS for PostgreSQL DB instance in eu-east-1 (Account_A) to an Amazon Redshift cluster in eu-west-1 (Account_B) using AWS Database Migration Service (AWS DMS), you need to set up an AWS DMS replication instance in the destination region, which is eu-west-1. This ensures that the replication instance is located in the same region as the target Amazon Redshift cluster, minimizing latency and adhering to AWS best practices. Therefore, the replication instance should be set up in Account_B in eu-west-1.
Redshift has to be in the same region as the DMS https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.Redshift.html#CHAP_Target.Redshift.Prerequisites
B - becuase AWS DMS must be in a same region as AWS redshift cluster https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.Redshift.html#CHAP_Target.Redshift.Prerequisites
Redshift needs to be in the same region as the replication instance see docs: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.Redshift.html#CHAP_Target.Redshift.Prerequisites
My Choice is D
The correct solution to replicate data between the Amazon RDS for PostgreSQL DB instance in Account_A (eu-east-1) and the Amazon Redshift cluster in Account_B (eu-west-1) using AWS Database Migration Service (AWS DMS) is: A. Set up an AWS DMS replication instance in Account_B in eu-west-1.
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.VPC.html
To enable AWS Database Migration Service (AWS DMS) to replicate data between two data stores in different AWS Regions, you should choose option A. Here’s why: Option A: Set up an AWS DMS replication instance in Account_B in eu-west-1. This approach allows you to configure replication between the Amazon RDS for PostgreSQL DB instance in eu-east-1 and the Amazon Redshift cluster in eu-west-1. By using AWS DMS, you can efficiently migrate data across Regions while minimizing downtime and ensuring data consistency