nerdexam
Microsoft

70-668 · Question #212

You have a SharePoint Server 2010 Service Pack 1 (SP1) server farm. The farm contains a database server that runs Microsoft SQL Server 2008 R2. You need to ensure that users can access SharePoint…

The correct answer is A. Database mirroring. See the full explanation below for the reasoning.

Question

You have a SharePoint Server 2010 Service Pack 1 (SP1) server farm. The farm contains a database server that runs Microsoft SQL Server 2008 R2. You need to ensure that users can access SharePoint sites in the event of a SQL Server storage failure. Which SQL Server technology should you implement?

Options

  • ADatabase mirroring
  • BMerge replication
  • CFailover Clustering
  • DTransactional replication
  • ESnapshot replication

How the community answered

(53 responses)
  • A
    74% (39)
  • B
    13% (7)
  • C
    4% (2)
  • D
    8% (4)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 70-668 Practice