For IndividualsFor Educators
ExpertMinds LogoExpertMinds
ExpertMinds

Ace your certifications with Practice Exams and AI assistance.

  • Browse Exams
  • For Educators
  • Blog
  • Privacy Policy
  • Terms of Service
  • Cookie Policy
  • Support
  • AWS SAA Exam Prep
  • PMI PMP Exam Prep
  • CPA Exam Prep
  • GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

    PracticeAWS Solutions Architect Professional (SAP-C02)AWS Solutions Architect Professional SAP-C02 Practice Exam 6Question 64
    Hard1 markMultiple Choice
    Domain 4.1: Select Workloads for MigrationMigrationDatabaseDMS

    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

    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.
    Question 63All questionsQuestion 65

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

    75 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01A global enterprise requires highly available hybrid connectivity between its on-premises data ce...HardQ02An organization has 50 VPCs across two AWS Regions connected via Transit Gateways (TGW). The TGWs...HardQ03A company uses AWS Organizations. The network team wants to share a central Transit Gateway (TGW)...MediumQ04An enterprise has on-premises data centers in the US and Europe. They want to use the AWS global ...HardQ05A company requires that all API calls to Amazon S3 from their VPC must not traverse the public in...Medium
    View all 75 questions →