Has anybody taken this certification exam? If so, how many years of experience do you have as a SQL Server DBA and how hard did you find the exam?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
closed as primarily opinion-based by Jack Douglas♦ Dec 12 '14 at 19:31
Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise.If this question can be reworded to fit the rules in the help center, please edit the question.
You can learn more reading Guide To MCITP: SQL Server 2008 Administration, but the impression I got was that the 70-432 is an exam to test your basic skills and can be handled by even an "accidental DBA" with the right amount of studying and exploration in SQL Server 2008 Developer's Edition
I'm preparing for this exam at the moment. I have quite a lot of experience as a database developer, but limited experience as a DBA. I'm finding preparing for the exam quite tricky. Typically for me when I want to do something, I would consult books online, and then complete the task. However with the exam, a lot of stuff is expected to be committed to memory.
I've found the official exam guide 'MCTS Self-Paced Training Kit (Exam 70-432) by Mike Hotek' to be reasonable, but not nearly comprehensive enough. I recommend using the guide as an outline and then looking at books online for additional detail. I think the reviews on Amazon are quite negative mainly because the guide won't give you all the information you need to pass the exam.
If you want a decent overview of DBA work with SQL Server try this book 'SQL Server 2008 Administration in Action by Rod Colledge'. While it is NOT an exam preparation guide it is reasonable if you want a second perspective. This book also doesn't cover some 'advanced' topics which I understand appear in the exam such as replication and some partition related topics.
Can anyone confirm that all the questions in the actual exam are multi-choice or are there simulation type questions as well? Also approximately how many questions are there likely to be?
While full-time professional DBAs with a number of years experience may be able to pass this test without significant preparation. Part-time and accidental DBAs will need to do quite a bit of work.