AWS Certified Database – Specialty — Question 102

A company has two separate AWS accounts: one for the business unit and another for corporate analytics. The company wants to replicate the business unit data stored in Amazon RDS for MySQL in us-east-1 to its corporate analytics Amazon Redshift environment in us-west-1. The company wants to use AWS DMS with
Amazon RDS as the source endpoint and Amazon Redshift as the target endpoint.
Which action will allow AVS DMS to perform the replication?

Answer options

• A. Configure the AWS DMS replication instance in the same account and Region as Amazon Redshift.
• B. Configure the AWS DMS replication instance in the same account as Amazon Redshift and in the same Region as Amazon RDS.
• C. Configure the AWS DMS replication instance in its own account and in the same Region as Amazon Redshift.
• D. Configure the AWS DMS replication instance in the same account and Region as Amazon RDS.

Correct answer: A

Explanation

The correct answer is A because AWS DMS requires the replication instance to be in the same account and Region as the target endpoint, which is Amazon Redshift in this case. Options B and D are incorrect as they do not meet the requirement of being in the same account and Region as Amazon Redshift. Option C is also incorrect since it suggests using a different account, which does not satisfy the replication requirements.