You administer a SQL Server 2008 infrastructure.
You plan to design an infrastructure for a new application.
The application has the following requirements:
Users can connect to an instance named SQLSERVER1.
SQLSERVER1 is linked to a server named SQLSERVER2.
SQLSERVER1 and SQLSERVER2 run on different computers.
The SQL Server instances use only Windows authentication.
You need to configure the infrastructure to ensure that the distributed queries are executed in the Windows
security context of the login.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You administer a SQL Server 2008 infrastructure.
You partition the largest table in a database into four equal-sized parts. The first two partitions are rarely queried. The third partition is frequently queried by several reports. The last partition is heavily queried and frequently modified.
You need to minimize the disk space of the table and ensure that this has minimum effect on the query performance.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You administer a SQL Server 2008 infrastructure.
A financial application uses several instances across multiple servers. The majority of queries require distributed transactions across all servers.
The application administrator reports that the application experiences excessive deadlocks.
You need to design a data collector type that provides the appropriate information for remote servers.
What collector should you use?

You administer a SQL Server 2008 infrastructure.
You discover that an instance experiences performance degradation for the following reasons:
Excessive CPU usage
Server processes paging
Deadlocks
You need to design a monitoring solution that can provide data, including detailed deadlock information, to
monitor and troubleshoot performance issues. You want to achieve this goal by using the minimum amount
of administrative effort.
What tool should you use?

You administer a SQL Server 2008 instance. The instance is using a 32-bit version on a Windows Server
2008 64-bit server. The awe enabled option is enabled.
The instance will experience a predictable increase in query activity.
You plan to ascertain the appropriate time when the migration of the databases to a 64-bit SQL Server
2008 server on the same hardware is beneficial.
You need to identify a data collector type that provides the appropriate information.
Which collector should you use?

You administer a SQL Server 2008 infrastructure.
Your company requires capacity planning information.
You need to design a long-term infrastructure monitoring strategy.
Which two tasks should you include in your design? (Each correct answer presents part of the solution.
Choose two.)

You administer a SQL Server 2008 infrastructure.
You design a corporate backup and recovery strategy that has to be validated.
You need to ensure the successful recovery of any single database from a catastrophic failure without
requiring a backup data center in a different location.
Which three tasks should you include? (Each correct answer presents part of the solution. Choose three.)

You administer a SQL Server 2008 instance that hosts a database solution in a production environment.
The database solution uses several SQL Server Agent jobs to periodically transfer data from
heterogeneous data sources to the production environment.
You also have a separate development environment that is used by several development teams.
You design a test recovery plan for the database.
You plan to test the recovery plan by performing the following tasks:
Restoring the database on a separate SQL Server 2008 instance in a development environment
Running a number of unit tests
You need to ensure that all database dependencies are included in the recovery plan.
Which two objects should you transfer from the production environment to the development environment?
(Each correct answer presents part of the solution. Choose two.)

You administer a SQL Server 2008 instance that hosts a large financial database.
The database has the following backup strategies:
A full database backup is performed once a week.
A differential backup is performed every day.
A transaction log backup is performed every hour.
You plan to execute an end-of-year batch process that takes two hours to run. The batch process will
modify about five percent of data within the database.
You need to ensure that if the Finance department does not approve the batch process, the batch
operation can be rolled back in minimum possible time.
What should you do prior to starting the batch process?