ExpertMedium1 markMultiple Choice
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)
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
Perform an Online migration using DMS, Configure a continuous sync of changes
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.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 5
55 questions · hints · full answers · grading
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