Recently I took and passed Exam 70-431: Microsoft SQL Server 2005-Implementation and Maintenance. I wasn’t sure I was going to pass it, so I was keeping my fingers crossed as the test calculated my score. My score was 841!
Here’s my take on the exam:
Lots and lots of simulations. You need to get some practice time with SQL Server Management Studio to pass the test. This part was hard because I usually write code to accomplish my tasks. I’m not much of a GUI user.
The MS prep guide is right on target. Use it as your study guide. You can find it at: http://www.microsoft.com/learning/exams/70-431.mspx
Study up on the major new features of SQL 2005 such as Database Mirroring, XML, Snapshots, and Service Broker.
Take your time and read the whole question!