DEA-C01 · Question #223
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…
The correct answer is B. Create an AWS Database Migration Service (AWS DMS) full-load task. Set Amazon Redshift as. AWS DMS can perform an initial full load of your on-premises PostgreSQL data into Redshift and then continuously capture and apply changes (CDC) over the VPN. This approach keeps your Redshift tables up to date with minimal latency and operational overhead.
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?
Options
- AUse the pg_dump utility to generate a backup of the PostgreSQL database. Use the AWS
- BCreate an AWS Database Migration Service (AWS DMS) full-load task. Set Amazon Redshift as
- CUse the pg_dump utility to generate a backup of the PostgreSQL database. Upload the backup to
- DCreate an AWS Database Migration Service (AWS DMS) full-load task. Set Amazon Redshift as
How the community answered
(36 responses)- A11% (4)
- B81% (29)
- C6% (2)
- D3% (1)
Explanation
AWS DMS can perform an initial full load of your on-premises PostgreSQL data into Redshift and then continuously capture and apply changes (CDC) over the VPN. This approach keeps your Redshift tables up to date with minimal latency and operational overhead.
Topics
Community Discussion
No community discussion yet for this question.