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 5Question 48
    Medium1 markMultiple Choice
    Domain 4.3: MigrationsDomain 4MigrationDatabase MigrationArchitecture

    AZ-305 · Question 48 · Domain 4.3: Migrations

    You are migrating a 5 TB on-premises Oracle database to Azure Database for PostgreSQL.

    The business requires that the migration results in less than 15 minutes of application downtime. You plan to use the Azure Database Migration Service (DMS).

    Which TWO actions must you perform to achieve this near-zero downtime migration? (Select TWO)

    Answer options:

    A.

    Perform an Offline migration using DMS.

    B.

    Perform an Online migration using DMS.

    C.

    Configure a continuous sync of changes.

    D.

    Use Azure Data Box to ship the database backup.

    E.

    Use Azure Site Recovery.

    How to approach this question

    Identify the migration type that allows the source to stay up (Online) and the mechanism that keeps the target updated until cutover (Continuous sync).

    Full Answer

    To achieve a near-zero downtime migration for a large database, you must use an 'Online' migration strategy with Azure Database Migration Service (DMS). In an online migration, DMS performs the initial full load of the 5 TB database while the on-premises Oracle database remains fully operational. Once the initial load is complete, DMS uses continuous synchronization (Change Data Capture) to replicate any new transactions to PostgreSQL. The 15-minute downtime only occurs during the final 'cutover', where you stop the application, allow the final few transactions to sync, and update the connection strings.

    Common mistakes

    Selecting Offline migration. Offline migration is simpler but requires the source database to be read-only or offline for the entire duration of the data copy.
    Question 47All questionsQuestion 49

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

    55 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01Contoso Ltd has 50 subscriptions across 3 business units. Each business unit manages its own IT o...EasyQ02You are designing a monitoring solution for a hybrid environment. The environment consists of 200...MediumQ03Your company uses Microsoft Sentinel integrated with a Log Analytics workspace. The workspace ing...HardQ04You are designing an application monitoring strategy using Application Insights. The application ...MediumQ05A highly regulated financial institution is migrating to Microsoft 365 and Azure. They currently ...Hard
    View all 55 questions →