A plan specifies current Azure DMS online migration from SQL Server to Azure SQL Database. The business cannot accept the measured offline outage. Which correction is appropriate?

Choose the single best answer.

A.Continue with DMS online mode because Managed Instance support implies SQL Database support
B.Reassess the target or another supported migration path
C.Rename the target to Managed Instance while retaining the same SQL Database service
D.Enable schema migration and treat that setting as a zero-downtime data-transfer feature

Show the answer and explanation

✓ Correct answer

Reassess the target or another supported migration path

Current DMS does not provide online migration to Azure SQL Database. A different supported approach or suitable target must be evaluated against requirements. Names do not change service capabilities, and schema preparation does not eliminate data synchronization or cutover. Source guide: PDF page(s) 63.

Read the source reference

This item is flagged for content review.

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.