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 4Question 50
    Medium1 markMultiple Choice
    Domain 4.3: Design MigrationsMigrationDatabaseDMS

    AZ-305 · Question 50 · Domain 4.3: Design Migrations

    You are designing the migration of a mission-critical 5 TB Oracle database to Azure Database for PostgreSQL.

    The business requires that the database migration results in near-zero downtime for the application. The application will be pointed to the new Azure database during a brief 15-minute maintenance window.

    Which migration strategy and tool should you recommend?

    Answer options:

    A.

    Offline migration using Azure Database Migration Service (DMS)

    B.

    Online migration using Azure Database Migration Service (DMS)

    C.

    Azure Data Box

    D.

    Azure Site Recovery

    How to approach this question

    Match 'near-zero downtime' to 'Online migration'. Offline migration causes downtime equal to the time it takes to copy the data.

    Full Answer

    B.Online migration using Azure Database Migration Service (DMS)✓ Correct
    An 'Online' migration using Azure Database Migration Service (DMS) is required for near-zero downtime. DMS copies the initial 5 TB of data while the source Oracle database remains online. Once the initial load is complete, DMS uses Change Data Capture (CDC) to continuously sync any new transactions. During the 15-minute window, you simply stop the application, let the final sync finish, and point the app to Azure.

    Common mistakes

    Choosing Offline migration. Offline is simpler but requires the application to be down for the entire duration of the 5 TB data copy.
    Question 49All questionsQuestion 51

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

    55 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ02CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ03CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...HardQ04CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ05CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...Hard
    View all 55 questions →