FEFreeExamDumps.in

Administering Microsoft Azure SQL Solutions

Topic 6

Question 241

DP-300 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.

Details →

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?

  • ACreate two proximity groups and two availability sets. Deploy each virtual machine to a unique availability set. Add one virtual machine to each proximity group.
  • BCreate a proximity group and an availability set. Deploy each virtual machine to the availability set. Add both virtual machines to the proximity group.
  • CCreate a proximity group and two availability sets. Deploy each virtual machine to a unique availability set. Add both virtual machines to the proximity group.
  • DCreate two proximity groups and a single availability set. Deploy both virtual machines to the availability set. Add one virtual machine to each proximity group.