ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 6 question 35 discussion

Actual exam question from Microsoft's DP-300
Question #: 35
Topic #: 6
[All DP-300 Questions]

You plan to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group.

You need to recommend a deployment solution that meets the following requirements:

• Provides a Service Level Agreement (SLA) of at least 99.95%
• Replicates databases in the same group synchronously
• Minimizes the latency of database writes

What should you recommend?

  • A. Create two proximity groups and two availability sets. Deploy each virtual machine to a unique availability set. Add one virtual machine to each proximity group.
  • B. Create a proximity group and an availability set. Deploy each virtual machine to the availability set. Add both virtual machines to the proximity group.
  • C. Create a proximity group and two availability sets. Deploy each virtual machine to a unique availability set. Add both virtual machines to the proximity group.
  • D. Create two proximity groups and a single availability set. Deploy both virtual machines to the availability set. Add one virtual machine to each proximity group.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by amazonalex at April 26, 2023, 9:27 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
yousiftech
10 months ago
This configuration, along with the use of availability sets and proximity groups, helps achieve high availability and reliability while minimizing the latency of database writes. Additionally, the SLA of at least 99.95% can be met with this deployment solution.
upvoted 2 times
...
OBIJUAN88
1 year ago
Selected Answer: B
To get VMs as close as possible, achieving the lowest possible latency, you should deploy them within a proximity placement group. https://learn.microsoft.com/en-us/azure/virtual-machines/co-location
upvoted 3 times
...
amazonalex
1 year ago
answer is correct
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago