(This was first posted on Usenet under microsoft.public.cert.mcdba and microsoft.public.cert.itpro.mcts on 12/24/2006).
I am happy to report that I took and passed the 70-431 exam Friday. It was not easy by any stretch but I did better than I thought I would. I know when I was preparing I was desperately hunting for exam reports. So, here goes:
I have 4-6 years of experience with SQL Server 2000 (and Access 97/2000 before that). I have a few months of SQL Server 2005 experience and about 6 months of Oracle training (classes, not a whole lot of experience).
I would suggest you invest in the Exam Cram 2 book for 70-431. I also bought the MS Press book but didn’t use it much. I found that the cram book was better at condensing the material down into what I needed to know. I liked the MS Press book but it is HUGE. I was crunched on time (I bought one of the voucher from VS 2005 launch), so I didn’t take any exam prep tests. However, I wouldn’t suggest anyone follow my lead there!!
I would stress that you need to know the product hands-on (I was weak in this area) and you need to know about the new features. I think everyone can figure out what those new features are, so I won’t list them. You, of course, need to be strong on database concepts ie. the various objects supported by SQL Server in general.
Feel free to ask any questions about my experience. I will answer what I can.
Jonathan
** For the official MS page on the exam (objectives, etc), go here: http://www.microsoft.com/learning/exams/70-431.mspx