A SQL workload is slow while CPU is moderate. Traces show long transactions holding locks and blocked sessions. What is the best first response?

Choose the single best answer.

A.Move the database into an elastic pool to eliminate transaction isolation
B.Reduce lock contention and tune the transactions/query plans
C.Double vCores without investigating locks
D.Add a readable geo-secondary to make primary lock waits disappear

Show the answer and explanation

✓ Correct answer

Reduce lock contention and tune the transactions/query plans

The measured bottleneck is contention, so shorten/tune the blocking work. Extra cores do not release locks. Read replicas do not resolve primary write contention. Pooling resources preserves database behavior and isolation. Source guide: PDF page 24.

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.