A SQL Server migration depends on SQL Agent jobs and supported cross-database queries. OS customization is unnecessary. Which service should be assessed first?

Choose the single best answer.

A.Azure SQL Managed Instance
B.SQL Server on Azure VMs solely because the source is a VM
C.Azure SQL Database as a single database
D.Azure Table storage

Show the answer and explanation

✓ Correct answer

Azure SQL Managed Instance

Managed Instance targets high instance compatibility and these supported dependencies without guest OS management. A single SQL Database has different instance capabilities. Table is not a SQL engine. Retaining a VM without a compatibility need adds operational responsibility. Source guide: PDF page 22-23.

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.