Finally I slayed the beast and passed 70-451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008. Pretty long name for a long exam. In fact, I passed this one back in November, but I can rarely find time to post (even this happy news).
The point is that now I’m an MCITP (for a long time, I pronounced it as MCTIP). The exam process was hard and sweating (I have failed my first attempt with 690 points) but in the end it worth it. I learned a lot of general database design, as a lot of SQL Server specific things, too. I can only suggest this exam to anyone, because you have to learn so many concepts that it helps a lot later.
About the exam itself: a bunch of multiple choice questions, mostly on theory, and underline that word twice, because that was what it’s all about. If you want to pass for the first time (not as I did) then check concurrency a lot, know the lock types, and have an eye for database normalization. The only thing I hated was the questions on row based logic. I never did any, nor will I intend to.
Anyway it’s nice to earn another title, and after I finished my semester (five days from now), I will surely find another exam to pass and post about.
Hi Konczuras
This exam seems quite tricky and its not easy to find materials for this exam. If you post about resources you used to pass it I would appreciate it.
Thanks
Hello!
Just look at the 70-451 category in the blog. I mostly used MSDN to prepare, and posted the results in that category.
Good luck for the exam!