Taking the Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 Exam

The Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 exam covers concepts and skills related to the optimization and maintenance of databases and SQL Server 2005 instances. It emphasizes the following elements of design:

• Optimizing the performance of database servers and databases

• Optimizing and implementing a data recovery plan for a database

• Designing a strategy to monitor and maintain a database solution

• Designing a database data management strategy

• Designing a strategy to manage and maintain database security

This exam will test your knowledge of how you can best use SQL Server 2005 to meet the business requirements of an organization in a cost-effective manner. This exam requires decision-making ability in all the areas just listed and an understanding of the implication of each of those decisions. To pass the test, you need to fully understand these topics. Careful study of this book, along with hands-on experience, will help you prepare for this exam.

Note 

Microsoft provides exam objectives to give you a general overview of possible areas of coverage on the Microsoft exams. Keep in mind, however, that exam objectives are subject to change at any time without prior notice and at Microsoft’s sole discretion. Please visit Microsoft’s Learning website (www.microsoft.com/learning) for the most current listing of exam objectives.