Exam NCA All QuestionsBrowse all questions from this exam
Question 38

A SQL Server cluster has been deployed on an AHV cluster. To ensure maximum uptime, the administrator wants the SQL Server VMs running on different hosts while leveraging High Availability in case of host failure.

Which configuration would meet these requirements?

    Correct Answer: C

    To ensure maximum uptime and make sure SQL Server VMs run on different hosts while leveraging High Availability in case of a host failure, creating an anti-affinity rule via CLI is necessary. Anti-affinity rules are used to separate VMs to run on different hosts, which helps in maintaining the availability of services even if one host fails.

Discussion
victorymOption: C

C. Create an anti-affinity rule via CLI.

avarma89Option: C

You can create anti-affinity rules to separate VMs. The simple use case for anti-affinity is when you run a cluster with applications such as Microsoft SQL or Exchange to ensure high availability (HA). If the application cluster nodes are running on same ESXi host, you will lose the entire application cluster when the host fails.