Question 285 of 919
DP-300 Practice Question: Monitor, configure, and optimize database resources
Your Azure SQL Database is configured with Active Geo-Replication to a secondary region for disaster recovery. During a routine failover drill, you notice that after failover, the application cannot connect to the new primary because the login credentials fail. The logins are contained in the master database. What is the most likely cause?
⚠ Common exam trap
A common mix-up: candidates assume all server-level configurations, including logins, are automatically replicated with geo-replication, but in reality, only user databases are replicated, not the master database.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The SQL logins in the master database are not replicated to the secondary server.
When Active Geo-Replication is configured for Azure SQL Database, the secondary server is a separate logical server in a different region. The master database, which contains server-level logins, is not replicated as part of geo-replication; only the user databases are replicated. Therefore, after a failover, the new primary server does not have the server-level logins from the original primary, causing authentication failures for applications using those logins.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The DNS name of the secondary server changed after failover.
Why it's wrong here
Failover groups handle DNS updates automatically.
- ✓
The SQL logins in the master database are not replicated to the secondary server.
Why this is correct
Active Geo-Replication replicates only user databases, not master database logins.
- ✗
The firewall rules on the secondary server do not allow connections from the application IP.
Why it's wrong here
Firewall rules can be configured in advance; the issue is about login authentication.
- ✗
The application uses contained database users, which are not replicated.
Why it's wrong here
Contained users are stored in the user database and are replicated.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jul 4, 2026
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.