Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Exam AZ-300 topic 2 question 11 discussion

Actual exam question from Microsoft's AZ-300
Question #: 11
Topic #: 2
[All AZ-300 Questions]

You have a Microsoft SQL Server Always On availability group on Azure virtual machines.
You need to configure an Azure internal load balancer as a listener for the availability group.
What should you do?

  • A. Create an HTTP health probe on port 1433.
  • B. Set Session persistence to Client IP.
  • C. Set Session persistence to Client IP and protocol.
  • D. Enable Floating IP.
Show Suggested Answer Hide Answer
Suggested Answer: D ūüó≥ÔłŹ
References:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-alwayson-int-listener

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
HS007
Highly Voted 3 years, 4 months ago
Step 4: Set the load balancing rules The load balancing rules configure how the load balancer routes traffic to the SQL Server instances. For this load balancer, you enable direct server return because only one of the two SQL Server instances owns the availability group listener resource at a time. Floating IP (direct server return) Enabled https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-alwayson-int-listener
upvoted 23 times
tartar
2 years, 8 months ago
D is ok
upvoted 1 times
us3r
1 year, 11 months ago
ok is ok
upvoted 3 times
...
...
...
Ssssaaahh
Most Recent 2 years, 8 months ago
D is correct
upvoted 2 times
...
gboyega
2 years, 10 months ago
D IS CORRECT
upvoted 3 times
...
AnilV
3 years, 3 months ago
Answer should be A
upvoted 2 times
Gorha
3 years, 1 month ago
D is correct. The rule uses TCP and not HTTP.
upvoted 8 times
Zixxer2Go
3 years ago
Using the link provided under the answer, "A" seems to be eliminated by the excerpt " You can use any available port. For example, 59999." when creating the Health Probe. As for "D", the excerpt under "Load Balancing Rules is "Floating IP (direct server return) - Enabled". "D" would be correct.
upvoted 4 times
azurecert2021
2 years, 4 months ago
yes D is correct.
upvoted 2 times
...
...
...
gboyega
2 years, 10 months ago
D is correct. the only time you use Floating Ip is for SQL Always On availabiltiy
upvoted 4 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
Loading ...