A company is migrating its 200 GB on-premises PostgreSQL database to Amazon Aurora PostgreSQL. The original database columns include NOT NULL and foreign key constraints. A database administrator needs to complete the migration while following best practices for database migrations. Which option meets these requirements to migrate the database to AWS?

Topic #: - All AWS Certified Database - Specialty Questions

A. Use the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS) to migrate the database to an Aurora PostgreSQL DB cluster.
B. Create an AWS Lambda function to connect to the source database and load the data into the target Aurora PostgreSQL DB cluster.
C. Use the PostgreSQL tools pg_dump and pg_restore to migrate to the Aurora PostgreSQL DB cluster.
D. Create an Aurora PostgreSQL read replica and promote the read replica to become primary once it is synchronized.

- Awsexamhub website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Suggested Answer:

Reference Material:

Suggested Answer:

Reference Material:

Share this post

Join the Discussion