ExpertMedium1 markMultiple Choice
AZ-305 · Question 48 · Domain 4.3: Design migrations
You are planning to migrate a 5 TB on-premises Oracle database to Azure Database for PostgreSQL.
The business requires that the migration process causes no more than 15 minutes of downtime for the application.
Which TWO components are required to achieve this near-zero downtime migration? (Select TWO)
You are planning to migrate a 5 TB on-premises Oracle database to Azure Database for PostgreSQL.
The business requires that the migration process causes no more than 15 minutes of downtime for the application.
Which TWO components are required to achieve this near-zero downtime migration? (Select TWO)
Answer options:
A.
Azure Database Migration Service (DMS) configured for Online migration.
B.
SQL Server Migration Assistant (SSMA) for Oracle (or Ora2Pg) for schema conversion.
C.
Azure Database Migration Service (DMS) configured for Offline migration.
D.
Azure Data Box
E.
Azure Site Recovery
How to approach this question
Identify the need for schema conversion (heterogeneous migration) and continuous data sync (Online migration for near-zero downtime).
Full Answer
Migrating from Oracle to PostgreSQL is a heterogeneous migration. First, you must convert the schema (tables, views, stored procedures) using a tool like SSMA for Oracle or Ora2Pg. Second, to meet the 15-minute downtime requirement for a 5 TB database, you must use Azure Database Migration Service (DMS) in 'Online' mode. Online mode performs an initial load and then continuously replicates changes (CDC) from Oracle to PostgreSQL. When you are ready, you stop the application, let the final few transactions sync, and cut over to Azure within minutes.
Common mistakes
Selecting Offline migration. Copying 5 TB over a network offline will take hours or days, causing massive downtime.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 1
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd is a global financial institution with 80 Azure subscriptions spread across 4 managem...MediumQ02Fabrikam Inc. operates a hybrid cloud environment with 500 on-premises VMware virtual machines ru...HardQ03A startup company has a single Azure subscription with a monthly budget of $5,000.
The CFO want...EasyQ04You are designing an Azure Sentinel architecture for a Managed Security Service Provider (MSSP). ...MediumQ05A healthcare enterprise is migrating its infrastructure to Azure. They have strict compliance req...Hard