nerdexam
AmazonAmazon

DEA-C01 · Question #223

DEA-C01 Question #223: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #223. The question stem and answer options stay visible for context.

Data Ingestion and Transformation

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

Unlock DEA-C01 to see the answer

You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Database Migration#Change Data Capture#AWS DMS#Amazon Redshift
Full DEA-C01 PracticeBrowse All DEA-C01 Questions