Which SQL Server 2008 R2 installation option should you…

###BeginCaseStudy###

Testlet 1
Overview
Litware, Inc. is a manufacturing company. Litware has a large data center and several offices.
Existing Environment
Network Infrastructure
The network contains a third-party network management device that supports SNMPv3. The network contains
network devices that support ICMP and SNMP and other devices that support SNMP only.
A group named Network Technicians contains the user accounts for the support technicians who manage all of
the network servers. The support technicians regularly install updates on the network servers.
System Center 2012 Infrastructure
Litware has all of the System Center 2012 components installed in the data centers. Service Manager is
integrated with Configuration Manager and Operations Manager.
The System Center 2012 Monitoring Pack for UNIX and Linux Operating Systems is installed on the Operations
Manager servers.
Software updates are deployed by using Windows Server Update Services (WSUS) and Configuration
Manager.
Virtualization Infrastructure
Litware has 30 Hyper-V hosts that run Windows Server 2008 R2. The Hyper-V hosts are members of failover
clusters.
Each office contains two virtual machines that run Microsoft SQL Server 2008 R2. The virtual machines are
configured in a failover cluster.
You have 100 virtual machines that run the following operating systems:
Windows Server 2012
Windows Server 2008 R2
Windows Server 2003 R2
Red Hat Enterprise Linux 6
SUSE Linux Enterprise Server 11
Application Infrastructure
Litware has a distributed application named App1 that is installed on several virtual machines.
The failover clusters host the databases used by App1. The components of App1 are in a service template and
a distributed application design.
Several other applications are installed on dedicated application servers. The application servers are deployed
as virtual machines.
Problem Statements
Litware identifies the following issues:
The primary service of App1, named App1Service, hangs frequently and logs events in the application log
on theserver where ApplService fails.
A recent security audit discovers that servers are vulnerable to attack due to misconfigurations of the
operating system.
Requirements
Planned Changes
Litware plans to implement the following changes:
Replace the third-party network monitoring solution by using a System Center 2012 solution. The System
Center 2012 solution must monitor all of the devices monitored by the third-party solution and must discovernew devices.
On all of the virtual machines that have App1 installed, update App1 to a new version.
Technical Requirements
Litware identifies the following technical requirements:
Application administrators must be able to back up and restore their respective application servers. Each
server must be backed up at a different time.
All virtual machines must be deployed by using virtual machine templates. The templates must be prepared
by using Sysprep.
All resolved Service Manager incidents must close automatically after 72 hours.
Availability Requirements
Litware identifies the following availability requirements:
Each request by a support technician to place a server in maintenance mode must be approved by a
network administrator.
App1 must have 99.99 percent availability.

###EndCaseStudy###

You are preparing a virtual machine that will be used as a template.
You need to install SQL Server 2008 R2 on the virtual machine. The solution must meet the technical
requirement for creating virtual machines.
Which SQL Server 2008 R2 installation option should you select?

###BeginCaseStudy###

Testlet 1
Overview
Litware, Inc. is a manufacturing company. Litware has a large data center and several offices.
Existing Environment
Network Infrastructure
The network contains a third-party network management device that supports SNMPv3. The network contains
network devices that support ICMP and SNMP and other devices that support SNMP only.
A group named Network Technicians contains the user accounts for the support technicians who manage all of
the network servers. The support technicians regularly install updates on the network servers.
System Center 2012 Infrastructure
Litware has all of the System Center 2012 components installed in the data centers. Service Manager is
integrated with Configuration Manager and Operations Manager.
The System Center 2012 Monitoring Pack for UNIX and Linux Operating Systems is installed on the Operations
Manager servers.
Software updates are deployed by using Windows Server Update Services (WSUS) and Configuration
Manager.
Virtualization Infrastructure
Litware has 30 Hyper-V hosts that run Windows Server 2008 R2. The Hyper-V hosts are members of failover
clusters.
Each office contains two virtual machines that run Microsoft SQL Server 2008 R2. The virtual machines are
configured in a failover cluster.
You have 100 virtual machines that run the following operating systems:
Windows Server 2012
Windows Server 2008 R2
Windows Server 2003 R2
Red Hat Enterprise Linux 6
SUSE Linux Enterprise Server 11
Application Infrastructure
Litware has a distributed application named App1 that is installed on several virtual machines.
The failover clusters host the databases used by App1. The components of App1 are in a service template and
a distributed application design.
Several other applications are installed on dedicated application servers. The application servers are deployed
as virtual machines.
Problem Statements
Litware identifies the following issues:
The primary service of App1, named App1Service, hangs frequently and logs events in the application log
on theserver where ApplService fails.
A recent security audit discovers that servers are vulnerable to attack due to misconfigurations of the
operating system.
Requirements
Planned Changes
Litware plans to implement the following changes:
Replace the third-party network monitoring solution by using a System Center 2012 solution. The System
Center 2012 solution must monitor all of the devices monitored by the third-party solution and must discovernew devices.
On all of the virtual machines that have App1 installed, update App1 to a new version.
Technical Requirements
Litware identifies the following technical requirements:
Application administrators must be able to back up and restore their respective application servers. Each
server must be backed up at a different time.
All virtual machines must be deployed by using virtual machine templates. The templates must be prepared
by using Sysprep.
All resolved Service Manager incidents must close automatically after 72 hours.
Availability Requirements
Litware identifies the following availability requirements:
Each request by a support technician to place a server in maintenance mode must be approved by a
network administrator.
App1 must have 99.99 percent availability.

###EndCaseStudy###

You are preparing a virtual machine that will be used as a template.
You need to install SQL Server 2008 R2 on the virtual machine. The solution must meet the technical
requirement for creating virtual machines.
Which SQL Server 2008 R2 installation option should you select?

A.
Install based on configuration file

B.
Image completion of a prepared stand-alone instance of SQL Server

C.
Image preparation of a stand-alone instance of SQL Server

D.
Advanced cluster preparation



Leave a Reply 0

Your email address will not be published. Required fields are marked *