StudyByteLearn
← AZ-305: Azure Infrastructure Solutions
AZ-305 · Integrated architecture scenarios · Relational data · Backup and disaster recovery

Practice question 387 of 400 · hard

A retailer uses an asynchronous SQL secondary for regional recovery. A forced failover occurs during heavy write load. Which two concerns require explicit testing? Select two answers.

Select all that apply. Every correct option and no extras are required for credit in the app.

  1. A.Automatic restoration of accidentally deleted rows through replication
  2. B.A guarantee that every acknowledged primary write exists at the secondary
  3. C.Elimination of all failover authorization requirements
  4. D.Application connection behavior and recovery-region capacity
  5. E.Possible loss of recent unreplicated writes
Show the answer and explanation

✓ Correct answers

  • Application connection behavior and recovery-region capacity
  • Possible loss of recent unreplicated writes

Asynchronous lag can lose recent writes, and recovery must restore a working application with capacity and connectivity. Async replication does not guarantee zero loss or reverse propagated deletion, and failover authority remains necessary. Source guide: PDF page(s) 65.

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.