A production Flexible Server must automatically fail over to a standby if the primary becomes unavailable. Which configuration achieves automatic failover?
- A Read replica promotion (manual)
- B Zone-redundant HA with automatic failover (no manual intervention) (correct answer)
- C pg_auto_failover extension self-managed
- D Azure Traffic Manager routing
Shortcut: Zone-redundant HA in Flexible Server automatically detects primary failure and fails over to the standby (typically within 60-120 seconds) without manual intervention. DNS is updated automatically.