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?

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 infrastructure.
The infrastructure contains SQL Server 2008 servers across four sites. All sites are connected via a WAN
link. All sites use the same database application.
Your company has the following business requirements:
All sites maintain data related to their site.
Each site has access to data related to other sites.
In the event of any site failure, database activity is redirected to another site.
You need to implement a replication topology that meets the business requirements.
Which solution should you implement?

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 SQL Server 2008 instances at three sites.
All sites share a mission-critical database. The business requirements specify that users at each site must
be able to perform the following tasks:
Access and modify data on all sites with minimal latency.
Minimize data loss in the event of a server failure.
You need to provide a high-availability solution that meets the business requirements.
Which solution should you implement?

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.

You administer a SQL Server 2008 instance.
The instance hosts a database that is used by a Web-based 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?