Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 112 discussion

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

The replication instance must be in the same Region as the source if the source is Amazon RDS (PostgreSQL in this case).

When you use WS DMS to migrate data between different AWS Regions or accounts, you must remember the following: The replication instance must be created in the same Region as the source database. The target endpoint must be created in the Region where the target data store is located. You must set up the required IAM roles and permissions to enable DMS to access the source and target resources.

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

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

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

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.

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

My Choice is D