yesterday I passed exam 70-450 PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 and I have became MCITP Database Administrator 2008. Now I want to share with you my exam and study experiences with you.
When you want to become MCITP Database Administrator 2008, you must first pass exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance. For this exam is very good book SQL Server 2008 Administration: Real-World Skills for MCITP Certification and Beyond (Exams 70-432 and 70-450) and official Microsoft Press Training kit with included MeassureUp practice test. For exam 70-450 I used Professional Microsoft SQL Server 2008 Administration book as a base.
I can't go into what the questions asked were, but my advice is – make sure you cover all new features provided with SQL Server 2008, and most admin stuff like database performance optimization, high availability etc. Download trial SQL Server 2008 [developer version] from Microsoft’s website and have at least 2 instances installed for your personal practise. If you attend any Microsoft launch event. they usually give away a licensed copy of SQL Server Standard edition. You don't need to install SQL Server 2008 R2, but it doesn't hurt to get familiar with that version.
Exam 70-432 – TS: Microsoft SQL Server 2008, Implementation and Maintenance
Installing and Configuring SQL Server 2008 (10 percent)
Maintaining SQL Server Instances (13 percent)
Managing SQL Server Security (15 percent)
Maintaining a SQL Server Database (16 percent)
Performing Data Management Tasks (14 percent)
Monitoring and Troubleshooting SQL Server (13 percent)
Optimizing SQL Server Performance (10 percent)
Implementing High Availability (9 percent)
Exam 70-450 – PRO: Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008
Designing a SQL Server Instance and a Database Solution (14 percent)
Designing a Database Server Security Solution (15 percent)
Designing a Database Solution for High Availability (15 percent)
Designing a Backup and Recovery Solution (20 percent)
Designing a Monitoring Strategy (13 percent)
Designing a Strategy to Maintain and Manage Databases (14 percent)
Designing a Strategy for Data Distribution (9 percent)