AWS SAP-C02 · Question 64 · Domain 4.1: Select Workloads for Migration
An architect is assessing an on-premises Oracle database for migration to AWS. The database uses complex stored procedures and proprietary Oracle features. The business wants to reduce licensing costs but cannot tolerate more than 1 hour of downtime during the cutover. Which THREE steps form the correct migration strategy? (Select THREE)
An architect is assessing an on-premises Oracle database for migration to AWS. The database uses complex stored procedures and proprietary Oracle features. The business wants to reduce licensing costs but cannot tolerate more than 1 hour of downtime during the cutover. Which THREE steps form the correct migration strategy? (Select THREE)
Answer options:
Use the AWS Schema Conversion Tool (SCT) to convert the schema and stored procedures to Amazon Aurora PostgreSQL.
Use AWS DataSync to copy the database files to S3.
Use AWS Database Migration Service (DMS) with Change Data Capture (CDC) enabled.
Perform a cold backup and restore to Amazon RDS for Oracle.
Validate the data, stop the on-premises application, wait for DMS to sync the final changes, and point the application to Aurora.
Use AWS Application Migration Service (MGN) to migrate the database server.
Use AWS Snowball Edge to transfer the database.
How to approach this question
Full Answer
Common mistakes
Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 6
75 questions · hints · full answers · grading
Expert