A hospital is migrating a 10 TB on-premises Oracle database to Azure Database for PostgreSQL.

The database supports a critical patient care application. The migration must result in near-zero downtime. The application can only be taken offline for a maximum of 15 minutes to update connection strings.

Which TWO tools/services must you use in combination to achieve this migration? (Select TWO)

Answer options:

Azure Data Box

Azure Database Migration Service (DMS) configured for online migration

Azure Site Recovery

SQL Server Migration Assistant (SSMA) for Oracle (or Ora2Pg) for schema conversion

Azure Database Migration Service (DMS) configured for offline migration

How to approach this question

Identify the need for schema conversion (heterogeneous migration) and continuous data sync (near-zero downtime).

Full Answer

Migrating from Oracle to PostgreSQL is a heterogeneous migration. First, you must convert the database schema (tables, views, stored procedures) using a tool like Ora2Pg or SSMA. Second, to achieve near-zero downtime for a 10 TB database, you must use Azure Database Migration Service (DMS) configured for 'online migration'. This performs an initial full load while the source is active, and then continuously replicates changes (Change Data Capture). When the sync is caught up, you take the brief 15-minute downtime to point the app to Azure.

Common mistakes

Forgetting that DMS only moves data, not schemas, in heterogeneous migrations. Schema conversion is a mandatory prerequisite step.

Question 47 All questions Question 49

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

55 questions · hints · full answers · grading

More questions from this exam

Q01Contoso Ltd is a global manufacturing company with 50,000 employees across 30 countries. They cur...Medium Q02Fabrikam Inc. is a Managed Service Provider (MSP) managing Azure environments for 50 different en...Hard Q03A financial institution generates 5 TB of telemetry and audit logs daily across its Azure environ...Medium Q04A retail company has recently migrated several workloads to Azure. The IT Director wants a centra...Easy Q05A healthcare organization with 10,000 employees uses on-premises Active Directory. They are migra...Hard

View all 55 questions →