AWS Certified Solutions Architect – Professional — Question 562

A company runs an application that gives users the ability to search for videos and related information by using keywords that are curated from content providers.
The application data is stored in an on-premises Oracle database that is 800 GB in size.
The company wants to migrate the data to an Amazon Aurora MySQL DB instance. A solutions architect plans to use the AWS Schema Conversion Tool and
AWS Database Migration Service (AWS DMS) for the migration. During the migration, the existing database must serve ongoing requests. The migration must be completed with minimum downtime.
Which solution will meet these requirements?

Answer options

• A. Create primary key indexes, secondary indexes, and referential integrity constraints in the target database before starting the migration process.
• B. Use AWS DMS to run the conversion report for Oracle to Aurora MySQL. Remediate any issues. Then use AWS DMS to migrate the data.
• C. Use the M5 or C5 DMS replication instance type for ongoing replication.
• D. Turn off automatic backups and logging of the target database until the migration and cutover processes are complete.

Correct answer: B

Explanation

To migrate heterogeneous databases like Oracle to Aurora MySQL, running a schema conversion assessment report is a critical first step to identify and remediate potential compatibility issues. Performing this assessment and fixing schema discrepancies ensures a smooth and reliable data migration using AWS DMS. Other options, such as creating all secondary indexes beforehand, can significantly degrade bulk-loading performance during the migration process.