ExpertMedium1 markMultiple Choice
AZ-305 · Question 46 · Domain 4.3: Migrations
You are migrating a mission-critical, on-premises Oracle database to Azure Database for PostgreSQL.
The database is 5 TB in size. The business requires that the migration be performed with near-zero downtime. The application will be pointed to the new Azure database during a brief 15-minute maintenance window.
Which TWO tools/services should you use in combination to achieve this? (Select TWO)
You are migrating a mission-critical, on-premises Oracle database to Azure Database for PostgreSQL.
The database is 5 TB in size. The business requires that the migration be performed with near-zero downtime. The application will be pointed to the new Azure database during a brief 15-minute maintenance window.
Which TWO tools/services should you use in combination to achieve this? (Select TWO)
Answer options:
A.
Azure Data Box
B.
Azure Database Migration Service (DMS)
C.
Azure Site Recovery (ASR)
D.
SQL Server Migration Assistant (SSMA) for Oracle
E.
Azure Data Factory
How to approach this question
Identify the tool for schema conversion (heterogeneous migration) and the tool for continuous data replication (online migration).
Full Answer
Migrating from Oracle to PostgreSQL is a heterogeneous migration. First, you must use a tool like SQL Server Migration Assistant (SSMA) or the Azure Schema Migration tool to assess the source database and convert the Oracle schema to a PostgreSQL-compatible schema. Second, to achieve near-zero downtime, you use Azure Database Migration Service (DMS) in 'Online' mode. DMS performs the initial load and then continuously replicates ongoing transactions until you are ready to cut over during the 15-minute window.
Common mistakes
Selecting Azure Data Box. While 5 TB is large, Data Box is an offline method. By the time the box arrives at the Azure datacenter, the data is days old, violating the near-zero downtime requirement.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 2
55 questions · hints · full answers · grading
More questions from this exam
Q01Fabrikam Inc. is a global financial services company with 200 Azure subscriptions managed via a c...HardQ02A healthcare organization has 500 on-premises Windows Server VMs and 300 Azure VMs. They are impl...HardQ03You are designing a security monitoring solution using Microsoft Sentinel.
The compliance depar...EasyQ04Your company has a microservices application deployed across multiple Azure App Service instances...MediumQ05A defense contractor is migrating to Microsoft 365 and Azure. They have a strict security policy ...Hard