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

Unlimited Access

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.

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 4 years, 6 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 24 times
tartar
3 years, 10 months ago
D is ok
upvoted 1 times
us3r
3 years, 1 month ago
ok is ok
upvoted 3 times
...
...
...
tashakori
Most Recent 4 months, 1 week ago
D is right
upvoted 1 times
...
Ssssaaahh
3 years, 10 months ago
D is correct
upvoted 2 times
...
gboyega
4 years ago
D IS CORRECT
upvoted 3 times
...
AnilV
4 years, 5 months ago
Answer should be A
upvoted 2 times
Gorha
4 years, 3 months ago
D is correct. The rule uses TCP and not HTTP.
upvoted 8 times
Zixxer2Go
4 years, 2 months 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
3 years, 6 months ago
yes D is correct.
upvoted 2 times
...
...
...
gboyega
4 years 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 ...
ex Want to SAVE BIG on Certification Exam Prep?
close
ex Unlock All Exams with ExamTopics Pro 75% Off
  • arrow Choose From 1000+ Exams
  • arrow Access to 10 Exams per Month
  • arrow PDF Format Available
  • arrow Inline Discussions
  • arrow No Captcha/Robot Checks
Limited Time Offer
Ends in