Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Steps
Order
1Step 1
2Step 2
3Step 3
4Step 4
5Step 5
AZ-900 Describe Azure architecture and services Practice Question
Order the steps to set up Azure SQL Database with geo-replication.
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
✓
1. Create Azure SQL Database, 2. Configure firewall rules, 3. Enable geo-replication, 4. Create failover group, 5. Test failover.
Geo-replication involves database creation, firewall, replication enablement, failover group, and testing.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
1. Create Azure SQL Database, 2. Configure firewall rules, 3. Enable geo-replication, 4. Create failover group, 5. Test failover.
Why this is correct
This order follows the logical sequence: database creation first, then firewall setup to allow access, then enabling geo-replication to establish the secondary replica, then creating a failover group to manage automatic failover, and finally testing failover to verify the setup.
- ✗
1. Create Azure SQL Database, 2. Enable geo-replication, 3. Configure firewall rules, 4. Create failover group, 5. Test failover.
Why it's wrong here
This order fails because firewall rules must be configured before enabling geo-replication. Geo-replication requires network connectivity between the primary and secondary servers, and without permissive firewall rules on both endpoints, the replication link cannot be established. Placing firewall configuration after geo-replication risks a failed setup or a partially configured secondary that cannot synchronize.
- ✗
1. Create Azure SQL Database, 2. Create failover group, 3. Enable geo-replication, 4. Configure firewall rules, 5. Test failover.
Why it's wrong here
This order is invalid because a failover group cannot be created before geo-replication establishes the secondary replica. A failover group is a container that manages one or more databases and requires an existing secondary database to add to the group; without geo-replication, there is no secondary to reference. Additionally, firewall rules must be in place before geo-replication to allow replication traffic to flow.
- ✗
1. Configure firewall rules, 2. Create Azure SQL Database, 3. Enable geo-replication, 4. Create failover group, 5. Test failover.
Why it's wrong here
This order is incorrect because firewall rules are scoped to an existing server or database; you cannot configure them before the Azure SQL Database resource is created. The firewall rule configuration step depends on having a logical server and database to apply rules to, so creating the database first is a mandatory prerequisite. Configuring firewall rules first is logically impossible and will result in an error.
Go deeper
Related to this question
Learn chapter
Azure Regions and Geographies
Key term
Group
A group is a collection of users, devices, or other objects that are assigned permissions and policies together for simplified management in identity and governance systems like Microsoft Entra ID.
Key term
Azure SQL Database
Azure SQL Database is a fully managed relational database-as-a-service (DBaaS) in Microsoft Azure, based on the SQL Server engine, that handles scaling, backups, patching, and high availability automatically.
About these practice questions
Courseiva writes every AZ-900 question from scratch — 981 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AZ-900 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 AZ-900 exam.