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?

Question

Accepted Answer

B. Use AWS DMS to run the conversion report for Oracle to Aurora MySQL. Remediate any issues

Answer

A. Create primary key indexes, secondary indexes, and referential integrity constraints in the target

Answer

C. Use the M5 or CS DMS replication instance type for ongoing replication.

Answer

D. Turn off automatic backups and logging of the target database until the migration and cutover

SAP-C02 Question #84: Real Exam Question with Answer & Explanation

Question

Options

Explanation

Community Discussion