AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 213

Question

A company has an on-premises PostgreSQL database that contains customer data. The company wants to migrate the customer data to an Amazon Redshift data warehouse. The company has established a VPN connection between the on-premises database and AWS. The on-premises database is continuously updated. The company must ensure that the data in Amazon Redshift is updated as quickly as possible. Which solution will meet these requirements?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Create an AWS Database Migration Service (AWS DMS) full-load task. Set Amazon Redshift as the target. Configure the task to use the change data capture (CDC) feature. Amazon Redshift is a managed petabyte-scale data warehouse for complex analytical queries. AWS Config tracks resource configuration changes and evaluates compliance. AWS Database Migration Service migrates databases with minimal downtime.

AWS Certified Data Engineer - Associate DEA-C01 — Question 213