Two SQL Server VMs are placed in an availability set, but no database replication or failover topology is configured. Which design work remains?

Choose the single best answer.

A.Only read routing because current replicas already exist automatically
B.Configure a supported availability group or failover-cluster design with quorum, listener connectivity, synchronization, and testing
C.Only a scale-set autoscale rule because it copies SQL transactions
D.Nothing because an availability set automatically configures SQL data replication

Show the answer and explanation

✓ Correct answer

Configure a supported availability group or failover-cluster design with quorum, listener connectivity, synchronization, and testing

VM placement reduces certain infrastructure risks but does not create SQL HA topology. Availability groups/clusters and associated coordination/connectivity must be configured; scaling/routing alone does not replicate the database. Source guide: PDF page 41.

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.