As an upgrade this exam contains elements from both 70-433 and 70-451. Like upgrade exams this allows people who have already got their MCITP to combine two exams into one so that they don’t have to pay for doing both exams. By doing this exam you will get two new certifications, the MCTS SQL Server 2008 Database Development and MCITP SQL Server 2008 Database Developer.
Since I had completed the previous MCITP and I have completed upgrade style exams before, I had an idea of how to go about this exam. I looked at the major changes from SQL 2005 to SQL 2008 and made sure to cover them. Also it should be noted that this exam does not cover the new changes in SQL Server 2008 R2.
Anyways, some information about the exam. The preparation materials for this exam as a whole are fairly limited in that there is no specific book for exam 70-454. However there is book for 70-433 (I didn’t use this) though I did use my own set of posts on 70-433. Additionally there is a sample exam on Measure Up for 70-433 but there is none for 70-451.
Again like my previous post on 70-566 the issue was again how to deal with the Pro part of the exam. I used articles in the MSDN library and the SQL Server Books online as well as a copy of SQL Server 2008 Enterprise Trial to make sure I could run through any of the concepts that are mentioned in the exam matrix for exam 70-451.
And finally the new logos after completing this exam