###BeginCaseStudy###
Case Study: 13

Fourth Coffee
Current Environment
Smart cards are deployed in the organization.
The company uses Microsoft SQL Server 2005 (64-bit) to host all of its databases. All SQL
servers run Windows Server 2003 R2.
The SQL Server databases are backed up by using SQL Server tools. Database administrators
manage and administer all of the SQL Server backups.
You plan to upgrade the Microsoft Office SharePoint Server 2007 server farm to SharePoint
Server 2010.
Technical Requirements
Fourth Coffee has the following technical requirements for the planned SharePoint Server
2010 deployment:
All user search results must display a thumbnail preview.
The server farm must be available if a single SQL server fails.
The server farm must be available during server patch maintenance.
Excel Services settings from SharePoint Server 2007 must be migrated to SharePoint Server
2010.
Business Requirements
Fourth Coffee has the following business requirements for the planned SharePoint Server
2010 deployment:
A separate Service Level Agreement (SLA) must be provided for each office.
Database administrators must be able to restore all the content of one office without
affecting the content of the other offices.
Security Requirement
All users must authenticate to the SharePoint server farm by using smart cards.

###EndCaseStudy###

You are a SharePoint administrator for Fourth Coffee. The company has 40 offices. You need to
recommend a database solution that meets the company’s technical requirements. Which database
solution should you recommend?

A.
encryption

B.
mirroring

C.
partitioning

D.
snapshots