You are a professional level SQL Sever 2008 Database Administrator. A solution will be
implemented to have hardware configurations obtained. The hardware configuration
obtained should include the number of processors on a computer and the processor type of
all SQL Server 2008 computers. The requirements listed below should be satisfied by the
solution. The solution should be hosted on the central computer. And the hardware
configurations for multiple servers should be verified by the solution. A technology should be
selected to satisfy the requirements, and the least amount of development effort should be
utilized. Which action should you perform to finish the task?

You are a professional level SQL Sever 2008 Database Administrator. It is on a
four-processor, quadcore server. CPU pressure is regularly experienced by the server. An
extremely large mission-critical database is consisted by the instance, and it is utilized
constantly. The online index rebuilds should not occupy all available CPU cycles. From the
following four configurations, which one should you utilize?

You are planning to upgrade a database application that uses merge replication. The table
currently has a column type of UNIQUEIDENTIFIER and has a DEFAULT constrain that
uses the NEWID() function. A new version of the application requires that the FILESTREAM
datatype be added to a table in the database. The data type will be used to store binary

files. Some of the files will be larger than 2 GB in size. While testing the upgrade, you
discover that replication fails on the articles that contain the FILESTREAM data. You find
out that the failure occurs when a file object is larger than 2 GB. You need to ensure that
merge replication will continue to function after the upgrade. You also need to ensure that
replication occurs without errors and has the best performance. What should you do? (More
than one answer choice may achieve the goal. Select the BEST answer.)

You administer a SQL Server 2008 infrastructure. You plan to deploy a new SQL Server
2008 multinode failover cluster. The failover cluster uses a storage area network (SAN) that
will use redundant array of independent disks (RAID) level 5. You need to format the logical
unit numbers (LUNs) for optimal performance of the database data files. Which of the
following is the best allocation unit size you should use?

You administer a SQL Server 2005 instance. The instance is configured to use the named
pipes network communication protocol. You plan to upgrade the instance to SQL Server
2008. You need to ensure that the upgraded instance can continue to use the named pipes
network communication protocol. You also need to ensure that the server uses the most
secure authentication method available. Which authentication method should you use?

You administer a SQL Server 2008 instance. Your company security policy is designed to
prevent changes to the server to the server configuration. You plan to use Policy-Based
Management Framework to implement the security policy. You need to ensure that the
policy is configured to meet the security requirement. What should you do?