You administer a SQL Server 2008 instance. You plan to deploy a new database that has
the following capacity requirements: 275 GB for the database data file 50 GB for the
transaction log file The storage array has six 100-GB disk drives available for the database.
The disks are attached to a redundant array of independent disks (RAID) controller that
supports RAID levels 0, 1, 5, and 10. The write performance of the transaction log needs to
be maximized. The database and transaction log files must be protected in the event of a
drive failure. You need to design the storage system. Which storage configuration should
you use?

You administer a SQL Server 2008 instance. The instance is located on a four-processor,
quad-core server. The server frequently experiences CPU pressure. The instance contains
a very large missioncritical database that is used continuously. You need to ensure that
online index rebuilds do not consume all available CPU cycles. Which configuration option
should you use?

You administer a SQL Server 2008 infrastructure. An instance runs on a computer that has
eight quad-core processors and 128-GB RAM. Four different applications use the instance.
The instance experiences a low number of CXPACKET waits. The instance also
experiences a large number of lazy writer waits. You need to optimize the performance of
the instance. What should you do?

You administer a SQL Server 2008 instance. The instance runs on a computer that has the
following features: A 64-GB RAM Four quad-core processors Several independent physical
raid volumes You plan to implement a transactional database on the instance. The
database is expected to have a high volume of INSERT, UPDATE, and DELETE activities.
The activities include creation of new tables. You need to optimize the performance of the
database by maximizing disk bandwidth and reducing the contention in the storage
allocation structures. What should you do?

You administer a SQL Server 2008 instance. You plan to deploy a new database to the
instance. The database will be subject to frequent inserts and updates. The database will
have multiple schemas. One of the schemas will contain a large amount of read-only
reference data. You need to design the physical database structure for optimal backup
performance. What should you do?

You administer a SQL Server 2008 instance. You deploy a new database named
Engineering. The Engineering database manages large documents that will be revised
occasionally. You need to design a table structure that allows fast read access. You also
need to minimize storage space requirements. Which two actions should you perform?
(Each correct answer presents part of the solution. Choose two.)

You administer a SQL Server 2008 Reporting Services (SSRS) instance. You plan to design
an authentication method for SSRS reports that use SQL Server data connections. You
need to ensure that all SSRS reports communicate to the SQL Server instance by using the
Kerberos authentication protocol. What should you do?

You administer a SQL Server 2008 instance. You plan to design the security requirements
for a new database application that will be deployed to the instance. The new database
contains a table that is created by using the following code segment: CREATE TABLE
EmpBonusPlan ( EmployeeID INT NOT NULL IDENTITY(1,1), NumOptions INT NOT NULL,
BaseSalary MONEY NOT NULL, BonusPlan VARBINARY(MAX) FILESTREAM ) You need
to ensure that the BonusPlan column is protected from unauthorized access by using the
most secure method. What should you do?

You administer a SQL Server 2008 instance. The instance hosts a database that is used by
a Webbased application. The application processes 15,000 transactions every minute. A
table in the database contains a column that is used only by the application. This column
stores sensitive data. You need to store the sensitive data in the most secure manner
possible. You also need to ensure that you minimize the usage of memory space and
processor time. Which encryption type should you use?

You administer a SQL Server 2008 instance. You plan to deploy a third-party database
application to the instance. The application uses stored procedures that are developed by
using SQL CLR integration. The application must be configured to enable the
EXTERNAL_ACCESS code access security setting. You need to ensure that the application
is deployed to the instance without loss of functionality. What should you do first?