Microsoft Exam Questions

What should you include in the solution?

You are a SharePoint administrator for Trey Research. The company policy and requirements are described in the Exhibit (Refer to the Exhibit).

You need to design a solution to ensure that all Web servers can access their databases if a single database server fails. Your solution must minimize costs. What should you include in the solution?

A.
Windows Network Load Balancing

B.
SQL Server log shipping

C.
Hardware load balancing

D.
Failover clustering

Explanation:
Q058
BURGOS MNEMO: “if a single database server fails” = “Failover clustering”

BURGOS COMMENTS:
About “NLB” in Q009, Q014, Q058:
IF “distributed across” only THEN Sandboxed
IF cluster solution for Web THEN “NLB”,
IF for SQL THEN Failover Cluster

ORIGINAL COMMENTS:
Failover clustering is the only solution that can be used by SQL Server databases to ensure accessibility after a single database server fails.