Row counts match after SQL migration, but a batch process fails and query latency is much higher. Which validation should have accompanied row counts?

Choose the single best answer.

A.Only a test that one administrator can open the Azure portal
B.Critical aggregates, identities, jobs, transactions, execution plans, and performance
C.Only a check that the target database name is unchanged
D.Only a screenshot of successful transfer status

Show the answer and explanation

✓ Correct answer

Critical aggregates, identities, jobs, transactions, execution plans, and performance

Migration validation must cover the application and surrounding behavior. Names, transfer screenshots, and portal access do not verify correctness, jobs, application authorization, or database performance. 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.