An Azure SQL service needs a faster regional recovery path than restoring a full geographically replicated backup. Some potential recent-write loss is acceptable during forced failover. Which design should be evaluated?

Choose the single best answer.

A.Geo-restore assumed always instantaneous with zero data gap
B.MARS file backup as the native SQL Database failover engine
C.A supported ready geographic database secondary or failover group alongside retained backups
D.TDE alone as a ready database in another region

Show the answer and explanation

✓ Correct answer

A supported ready geographic database secondary or failover group alongside retained backups

A ready secondary can reduce activation work compared with geo-restore, while asynchronous forced failover can lose recent writes and backups preserve history. TDE and MARS do not supply SQL PaaS regional replication. Source guide: PDF page 38-39.

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.