ExpertHard1 markMultiple Choice
AZ-305 · Question 51 · Domain 4.3: Migrations
You are migrating a mission-critical on-premises SQL Server database to Azure SQL Managed Instance. The migration must have near-zero downtime. Which TWO components should you use? (Select TWO)
You are migrating a mission-critical on-premises SQL Server database to Azure SQL Managed Instance. The migration must have near-zero downtime. Which TWO components should you use? (Select TWO)
Answer options:
A.
Azure Database Migration Service (DMS)
B.
Online migration
C.
Offline migration
D.
Azure Data Factory
E.
Azure Site Recovery
How to approach this question
Identify the DB migration tool and the mode for zero downtime.
Full Answer
DMS with Online migration performs an initial load and then continuously syncs changes, allowing for a quick cutover. Pillar: Reliability.
Common mistakes
Selecting Offline migration which causes extended downtime.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 7
55 questions · hints · full answers · grading
More questions from this exam
Q01CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...HardQ02CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...MediumQ03CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...HardQ04CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...MediumQ05CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...Hard