Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

Just curious, why 70-432 but not 70-462 - Administering Microsoft SQL Server 2012 Databases (the most recent one)? – gmsantos Jul 24 '14 at 0:18
@gmsantos What is the difference between 70-432 and 70-462? – user54945 Dec 12 '14 at 18:33
@TamWol 462 is SQL 2012 Administering and 432 is SQL 2008 Implementation and Maintenance – John M Dec 12 '14 at 19:32
up vote 2 down vote accepted

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

70-432 is the basic exam and covers a range of general SQL Server administration areas. 70-450 is more advanced and covers all the areas of 70-432, plus higher-level DBA tasks such as high availability and infrastructure design. Be aware that all questions are multiple-choice (more on this later).

share|improve this answer

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.

share|improve this answer