Exam DP-300 topic 6 question 3 discussion

The answe should be A. Failover groups don't require changes on the connection string. Geo replica does.

Yes, Geo-replication requires a change of connection string, can't be the right answer

geo-replication needs connection string change during failover so, Answer is A - Failover groups

as of August 2023 (these things change quite a lot): answer is A it is Azure SQL database, NOT SQL MI. https://learn.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-sql-db?view=azuresql&tabs=azure-powershell - "Auto-failover groups support geo-replication of all databases in the group to only one secondary logical server in a different region. If you need to create multiple Azure SQL Database geo-secondary replicas (in the same or different regions) for the same primary replica, use active geo-replication."

Correct answer is D: Active geo-replication asynchronously replicates committed transactions from a primary database to up to four secondary databases located in different regions. This allows for failover to one of the secondary databases in the event of a regional outage or other disaster affecting the primary database, without the need for the client applications to update their connection strings. The secondary database can be configured to automatically take over as the new primary database in case of a failure.

The answer is A, as no need to change connection sting once applications has read/write connction string

The answer is A.

A is correct https://azure.microsoft.com/en-us/blog/azure-sql-database-now-supports-transparent-geographic-failover-of-multiple-databases-featuring-automatic-activation/

You no longer need to worry about changing SQL connection string after failover. Each auto-failover group includes two connection endpoints. The read-write endpoint is a DNS name that will always point to the primary database and will automatically switch during failover. The read-only endpoint is a DNS name that points to the secondary server and allows using the secondary databases to load balance the read-only workloads.

The answer is A as you will need to change connection string with Geo replica; hence Geo replica cannot be the answer.

It should be Failover groups. Geo replica requires CS change.

The answer is A. There is no question, just do it. 100%. Reason: Geo-Replication requires Connection String change. Failover Groups do not.

Ans is A The link clearly show that https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview "Update connection strings in your application accordingly."

A failover group is a prerequisite to activate geo-replication on the database. Since the question is about the database it should be D in my opinion.

Answer is A: Failure groups does not require update connection string on app side. geo-active requires.

A is the correct answer

Answer is "A. Failover Groups" and NOT "D. geo replication" cause one of the requirements is to support failovers that do not require client applications to change their connection strings. Failover groups allow this but geo replication does not.