ExpertMedium1 markMultiple Choice
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?
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
Online migration using Azure Database Migration Service (DMS)
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.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 4
55 questions · hints · full answers · grading
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