Hard1 markMultiple Choice

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)

Answer options:

A.

Use the AWS Schema Conversion Tool (SCT) to convert the schema and stored procedures to Amazon Aurora PostgreSQL.

B.

Use AWS DataSync to copy the database files to S3.

C.

Use AWS Database Migration Service (DMS) with Change Data Capture (CDC) enabled.

D.

Perform a cold backup and restore to Amazon RDS for Oracle.

E.

Validate the data, stop the on-premises application, wait for DMS to sync the final changes, and point the application to Aurora.

F.

Use AWS Application Migration Service (MGN) to migrate the database server.

G.

Use AWS Snowball Edge to transfer the database.

How to approach this question

Identify the tools for heterogeneous database migration with minimal downtime.

Full Answer

A, C, E
To reduce licenses, migrate to an open-source engine (Aurora PostgreSQL) using AWS SCT to convert the schema. Use AWS DMS with CDC to replicate data continuously. The cutover involves stopping the source, letting the final sync finish, and updating DNS/connection strings.

Common mistakes

Choosing MGN, which would just lift-and-shift the Oracle server, maintaining the high licensing costs.

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

75 questions · hints · full answers · grading

More questions from this exam