Before moving a heavily loaded SQL Server to Azure, a consultant wants the Azure SQL migration tooling to gather live workload counters and suggest which Azure SQL service tier and compute size would fit. Which feature provides this?
Show answer and explanation
Answer: A
The Azure SQL migration extension in Azure Data Studio can collect performance counters from the source and produce a right-sized recommendation for an Azure SQL target. It bases the suggestion on observed workload rather than only static server specifications. The other options check integrity, schedule jobs or raise alerts, and none of them size a target.
Why the other options are wrong
- B. DBCC CHECKDB verifies database consistency and reports corruption. It does not collect workload metrics or recommend a cloud service tier.
- C. Elastic jobs run T-SQL across many Azure SQL Databases on a schedule. They do not profile a source server or recommend target sizes.
- D. SQL Server Agent alerts respond to events such as errors or performance conditions on a running instance. They notify operators but do not produce a migration sizing recommendation.