A SQL application depends on server-level jobs, linked servers, and extensions. The team has chosen a transfer tool before assessing these features. What is the best next step?

Choose the single best answer.

A.Choose Azure SQL Database and assume all server-level SQL dependencies are supported
B.Discard server-level jobs and extensions before identifying the application dependencies
C.Assess compatibility, select a target, and then select tooling
D.Copy tables first and accept the move solely from matching source and target row counts

Show the answer and explanation

✓ Correct answer

Assess compatibility, select a target, and then select tooling

Target capabilities and operating requirements constrain the migration workflow. Azure SQL Database, Managed Instance, and SQL on VMs differ; table copies omit jobs and behavior; removal without assessment can break the application. 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.