Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
You have the Azure SQL Database servers shown in the following table. You plan to specify sqlserver1 as the primary server in a failover group. Which servers can be used as a secondary server?
A.
sqlserver4 and sqlserver5 only
B.
sqlserver2 and sqlserver3 only
C.
sqlserver2, sqlserver3, sqlserver4, and sqlserver5
Suggested Answer:D🗳️
The Resource Group must be the same. The secondary server can have another location. The secondary server cannot be the same as the primary server. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-configure
Correct answer should be A (sqlserver4 & sqlserver5). Per doc, the secondary cannot be in the same region as the primary.
https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell#terminology-and-capabilities
Failover groups cannot be created between two servers or instances in the same Azure region.
https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell
The correct answer is D. I tested this, location can be the same it selects a different availability zone, Server5 is in RG2 which is not configurable, failgroup servers must be in the same RG
It's A and below question in training:
You are advising an auto parts company that is running the following Azure SQL Database servers:
OEM_SQLSvr_1:
Resource Group: Resource_Group_1
Location: East US
OEM_SQLSvr_2:
Resource Group: Resource_Group_1
Location: East US
OEM_SQLSvr_3:
Resource Group: Resource_Group_1
Location: North Europe
OEM_SQLSvr_4:
Resource Group: Resource_Group_2
Location: North Europe
The plan to make OEM_SQLSvr_1 as the primary server within a failover group.
Which server should you recommend as the secondary server?
OEM_SQLSvr_3 and OEM_SQLSvr_4
OEM_SQLSvr_2 and OEM_SQLSvr_3
OEM_SQLSvr_2 and OEM_SQLSvr_4
Explanation
Correct answer: OEM_SQLSvr_3 and OEM_SQLSvr_4. OEM_SQLSvr_1 is located in East US, and both OEM_SQLSvr_3 and OEM_SQLSvr_4 are located in North Europe.
Answer should be A.
Primary
The server or managed instance that hosts the primary databases in the failover group.
Secondary
The server or managed instance that hosts the secondary databases in the failover group. The secondary cannot be in the same region as the primary.
I think, Resource groups come into picture here. in Azure it is all about regions. Hence primary and secondary should be in different region, sqlserver2 is incorrect and correct answer is A.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
JimmyJones
Highly Voted 3 years, 3 months agordemontis
2 years, 9 months agoASRDIAS
2 years, 11 months agojaydee7
2 years, 1 month agoMichaelCWWong
Highly Voted 3 years, 3 months agosachinp2305
Most Recent 2 years agoitvinoth83
2 years agoKemalM
2 years, 2 months agoshree178
2 years, 2 months agocomando
2 years, 2 months agonews101
2 years, 3 months agoplmmsg
2 years, 3 months agoDawn7
2 years, 3 months agoxyz213
2 years, 3 months agoazureaakuu
2 years, 3 months agoAnand3011
2 years, 4 months agops_yad
2 years, 4 months agoAbhishek1950
2 years, 5 months agosoonwing
2 years, 5 months agoAkanksha786
2 years, 6 months ago