You administer a SQL Server 2008 instance. You plan to design the security requirements
for a new database application. The application uses a code segment that contains the
following components: A method that accesses the registry on the SQL Server. A method
that accesses the file system on a network file server. A class definition that uses public
static fields The code segment uses SQL CLR integration and is implemented as a single
assembly. You need to ensure that the application is successfully deployed to the instance.
What should you do?

You administer a SQL Server 2008 instance that will host a new database application. You
plan to design the security requirements for the application. Each application user has a
unique login to the SQL Server 2008 server. The application database contains stored
procedures to execute stored procedures in the MSDB database. The stored procedures in
the MSDB database schedule SQLAgent jobs. You need to ensure that the stored
procedures in the MSDB database are executed by using the security context of the
application user. What should you do?

You administer a SQL Server 2008 instance. The instance hosts a new database
application. You plan to design the data security strategy for the application. You will use
Snapshot replication to replicate the data to another instance of SQL Server 2008. You
need to ensure that all stored data is encrypted by using the least amount of administrative

effort. What should you do?

You administer SQL Server 2008 servers on a single site. The site contains the following
two SQL Server 2008 instances: An Enterprise Edition server on a server that has a
redundant array of independent disks (RAID) 10 disk system A Standard Edition server
on a server that has a RAID 5 disk system Each instance hosts a single application. You
need to recommend a high-availability solution for the site to meet the following business
requirements: The solution can be implemented on the existing systems. The database
is available with minimal downtime. Data loss is minimal. There is minimal effect on the
existing system. What are two possible ways to achieve this goal? (Each correct answer
presents a complete solution. Choose two.)

You administer a SQL Server 2008 infrastructure. An instance hosts a business-critical
database that must be continuously available to the users without data loss. The database
includes Filestream data. You need to implement a high-availability solution for the site.
Which solution should you use?

You administer four SQL Server 2008 instances. Each instance hosts a single database
application. You plan to migrate all four instances to a new SQL Server failover cluster. The
four instances are configured as shown in the following table. The four instances are fully
optimized and have no spare CPU cycles or extra memory. The new cluster will host all four
databases on a single virtual cluster IP address. You need to ensure that the new cluster is
configured to handle the workload of all the database applications by using the minimum
amount of hardware resources. Which cluster configuration should you use?

You administer a SQL Server 2008 instance. The instance hosts a database configured by
using highsafety mirroring operation mode along with a witness server. The witness server
is experiencing memory failure and will be offline for four hours. You need to reconfigure the
mirroring strategy to minimize the risk of database unavailability. What should you do?

You administer a SQL Server 2008 instance. The instance is one of three servers in a

peer-to-peer transactional replication topology. The publication contains a table named
Orders. The Orders table contains 200 GB of data across multiple partitions. A batch
process bulk loads 10 GB of data to the Orders table periodically. You need to design a
replication strategy to minimize latency. What should you do?

You administer a SQL Server 2008 infrastructure. You implement log shipping for several
databases on three SQL Server instances. The logs are shipped to a fourth SQL Server
instance. You plan a manual failover. You need to ensure that the database applications
use the secondary server after failover. You also need to ensure that users can access the
most recent data. Which three tasks should you perform? (Each correct answer presents
part of the solution. Choose three.)

You administer a SQL Server 2008 instance that hosts a large database. The database
experiences high volumes of queries and transactions that are processor-intensive. You
plan to implement an incremental backup strategy for the database. You also plan to use
backup compression. You need to ensure that the backup jobs have a minimal effect on the
performance of the server. What should you do?