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.

    PracticeAzure Solutions Architect Expert (AZ-305)Azure Solutions Architect Expert AZ-305 Practice Exam 3Question 48
    Hard1 markMultiple Choice
    Domain 4.3: Design migrationsDomain 4MigrationsDatabase Migration ServiceHeterogeneous

    AZ-305 · Question 48 · Domain 4.3: Design migrations

    A hospital is migrating a 10 TB on-premises Oracle database to Azure Database for PostgreSQL.

    The database supports a critical patient care application. The migration must result in near-zero downtime. The application can only be taken offline for a maximum of 15 minutes to update connection strings.

    Which TWO tools/services must you use in combination to achieve this migration? (Select TWO)

    Answer options:

    A.

    Azure Data Box

    B.

    Azure Database Migration Service (DMS) configured for online migration

    C.

    Azure Site Recovery

    D.

    SQL Server Migration Assistant (SSMA) for Oracle (or Ora2Pg) for schema conversion

    E.

    Azure Database Migration Service (DMS) configured for offline migration

    How to approach this question

    Identify the need for schema conversion (heterogeneous migration) and continuous data sync (near-zero downtime).

    Full Answer

    Azure Database Migration Service (DMS) configured for online migration, SQL Server Migration Assistant (SSMA) for Oracle (or Ora2Pg) for schema conversion
    Migrating from Oracle to PostgreSQL is a heterogeneous migration. First, you must convert the database schema (tables, views, stored procedures) using a tool like Ora2Pg or SSMA. Second, to achieve near-zero downtime for a 10 TB database, you must use Azure Database Migration Service (DMS) configured for 'online migration'. This performs an initial full load while the source is active, and then continuously replicates changes (Change Data Capture). When the sync is caught up, you take the brief 15-minute downtime to point the app to Azure.

    Common mistakes

    Forgetting that DMS only moves data, not schemas, in heterogeneous migrations. Schema conversion is a mandatory prerequisite step.
    Question 47All questionsQuestion 49

    Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 3

    55 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01Contoso Ltd is a global manufacturing company with 50,000 employees across 30 countries. They cur...MediumQ02Fabrikam Inc. is a Managed Service Provider (MSP) managing Azure environments for 50 different en...HardQ03A financial institution generates 5 TB of telemetry and audit logs daily across its Azure environ...MediumQ04A retail company has recently migrated several workloads to Azure. The IT Director wants a centra...EasyQ05A healthcare organization with 10,000 employees uses on-premises Active Directory. They are migra...Hard
    View all 55 questions →