A company is migrating a large PostgreSQL database to Amazon Aurora PostgreSQL. The database is currently 15 TB. The company wants to minimize downtime during the cutover. They are using AWS Database Migration Service (DMS) with Change Data Capture (CDC). During the full load phase, the migration is taking too long. How can the architect speed up the full load phase?

Answer options:

Increase the network bandwidth of the AWS Direct Connect connection.

Configure DMS to use parallel load for large tables by specifying table partitions or boundaries.

Switch from AWS DMS to AWS DataSync.

Disable CDC during the full load phase.

How to approach this question

Identify DMS optimization techniques.

Full Answer

B.Configure DMS to use parallel load for large tables by specifying table partitions or boundaries.✓ Correct

Configure DMS to use parallel load for large tables by specifying table partitions or boundaries.

For very large tables, AWS DMS can be configured to use parallel load. By defining table partitions or boundaries, DMS can spawn multiple threads to extract data concurrently, drastically reducing the full load time.

Common mistakes

Assuming network bandwidth is the issue without optimizing the DMS task configuration.

Question 52 All questions Question 54

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 7

75 questions · hints · full answers · grading

More questions from this exam

Q01A global enterprise is designing a multi-region network architecture connecting 50 AWS accounts a...Hard Q02A company is migrating its hybrid network to AWS. They have two 10 Gbps AWS Direct Connect connec...Hard Q03An enterprise has 100 AWS accounts in AWS Organizations. The security team mandates that all Amaz...Medium Q04A financial company requires that all EBS volumes, S3 buckets, and RDS databases be encrypted usi...Easy Q05An enterprise is designing a disaster recovery strategy for a critical application running on Ama...Hard

View all 75 questions →