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 2Question 46
    Medium1 markMultiple Choice
    Domain 4.3: MigrationsDomain 4Database MigrationDMSOracle to PostgreSQL

    AZ-305 · Question 46 · Domain 4.3: Migrations

    You are migrating a mission-critical, on-premises Oracle database to Azure Database for PostgreSQL.

    The database is 5 TB in size. The business requires that the migration be performed with near-zero downtime. The application will be pointed to the new Azure database during a brief 15-minute maintenance window.

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

    Answer options:

    A.

    Azure Data Box

    B.

    Azure Database Migration Service (DMS)

    C.

    Azure Site Recovery (ASR)

    D.

    SQL Server Migration Assistant (SSMA) for Oracle

    E.

    Azure Data Factory

    How to approach this question

    Identify the tool for schema conversion (heterogeneous migration) and the tool for continuous data replication (online migration).

    Full Answer

    Azure Database Migration Service (DMS), SQL Server Migration Assistant (SSMA) for Oracle
    Migrating from Oracle to PostgreSQL is a heterogeneous migration. First, you must use a tool like SQL Server Migration Assistant (SSMA) or the Azure Schema Migration tool to assess the source database and convert the Oracle schema to a PostgreSQL-compatible schema. Second, to achieve near-zero downtime, you use Azure Database Migration Service (DMS) in 'Online' mode. DMS performs the initial load and then continuously replicates ongoing transactions until you are ready to cut over during the 15-minute window.

    Common mistakes

    Selecting Azure Data Box. While 5 TB is large, Data Box is an offline method. By the time the box arrives at the Azure datacenter, the data is days old, violating the near-zero downtime requirement.
    Question 45All questionsQuestion 47

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

    55 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01Fabrikam Inc. is a global financial services company with 200 Azure subscriptions managed via a c...HardQ02A healthcare organization has 500 on-premises Windows Server VMs and 300 Azure VMs. They are impl...HardQ03You are designing a security monitoring solution using Microsoft Sentinel. The compliance depar...EasyQ04Your company has a microservices application deployed across multiple Azure App Service instances...MediumQ05A defense contractor is migrating to Microsoft 365 and Azure. They have a strict security policy ...Hard
    View all 55 questions →