DP-300 Certification Practice Question #285

Question

What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?

Accepted Answer

SalesSQLDb1 uses active geo-replication (not auto-failover groups). Unlike failover groups which provide static listener endpoints that redirect automatically, geo-replication has no such listener. When a geo-failover occurs, the secondary becomes the new primary on its own server address, requiring the application (SalesSQLDb1App1) to update its connection string to point to the new primary server. Firewall rules are already replicated to the secondary, so option C is unnecessary. All significant community voices and the Suggested/Most Voted answer agree on B.

More DP-300 practice questions