locked
Newbie Questions RRS feed

  • Question

  • I have been working with SQL Server for the past 6 years as a SQL programmer.  I am gradually taking over the DBA role and want to take the DBA certification test 70-462.  My organization is still using SS 2005 and I was given a study book that covers 2005.  I understand I need an updated book to successfully study for this exam. I was going to get the 2008 Study Kit but am concerned that the test will cover 2012.

    What is the latest SS version that will appear on the test?

    Also, upon passing the test do I get some type of certificate that states I passed the "Administering Microsoft SQL Server Databases" test?

    Monday, January 14, 2013 7:23 PM

Answers

  • Hi,

    I wanted to add to what Sean already mentioned. Here are some links for a couple of really good books. Based on what you wrote, you may want to start with the training kit. It does a great job of covering the breadth and depth of the topics that may be covered on the exam.

    70-462 Training Kit, http://www.amazon.com/Training-Kit-Exam-70-462-Administering/dp/0735666075/ref=sr_1_1?ie=UTF8&qid=1358255750&sr=8-1&keywords=70-462

    70-462 Rapid Review, http://www.amazon.com/Rapid-Review-70-462-Administering-Microsoft/dp/0735666911/ref=sr_1_4?ie=UTF8&qid=1358255750&sr=8-4&keywords=70-462

    Also, please take a look at the following link. There have been a lot of changes to the certifcation program since SQL 2005. This link will give you more information: http://www.microsoft.com/learning/en/us/mcsa-sql-certification.aspx

    Lastly, Microsoft is currently running a promotion called Second Shot. It gives you a free retake if you do not pass the exam the first time. You do need to sign up for the program before you register for the exam.  Here is the information: http://www.microsoft.com/learning/en/us/second-shot.aspx

    Good luck! 


    Mike Corkery, MCT, MVP (Office Systems), MCSD (Windows Store Apps), MCITP, MCPD, MSF, etc. Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer”if it solves the issue.

    • Proposed as answer by Mr. Wharty Tuesday, January 15, 2013 9:30 PM
    • Marked as answer by Mr. Wharty Tuesday, January 15, 2013 9:30 PM
    Tuesday, January 15, 2013 1:21 PM
  • Hi,

    The 70-462 will cover SQL 2012 and you should prepare by making sure you have a solid grasp of the new technologies in SQL 2012 such as availability groups, always on, column store indexes, etc. I have not taken this exam so no NDA however they usually test fairly strongly on the new features.

    If you are only using SQL 2005 at work you are going to need to setup SQL 2012 in a lab and play with it.

    Certificates can be purchased however you will have your test score report showing you passed and what score you recieved you can also print your offical transcript from the MCP site or share your transcript online with others.


    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

    • Marked as answer by MrAndrewwayne Tuesday, January 15, 2013 4:04 PM
    Monday, January 14, 2013 8:43 PM
  • There is no official retirement date for 70-432 that I can see however it is confusing as the other SQL 2008 exams retire 31st July 2013. Therefore if ou want the MCTS or MCITP SQL 2008 you need to complete the 432 for just MCTS plus 450 exams for MCITP by this date otherwise you can go for MCSA SQL 2008 which requires 432 and 448.

    *Note that this MCTS certification will only be awarded until July 31, 2013.
    Exam 70-432: Microsoft SQL Server 2008, Implementation and Maintenance: counts as credit toward the following certification(s):

    *Note that this MCITP certification will only be awarded until July 31, 2013. After that date, exam 432 will continue to count towards the MCSA: SQL Server 2008 certification. -

    see http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-432


    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

    • Marked as answer by MrAndrewwayne Wednesday, January 23, 2013 9:51 PM
    Wednesday, January 23, 2013 9:38 PM

All replies

  • Hi,

    The 70-462 will cover SQL 2012 and you should prepare by making sure you have a solid grasp of the new technologies in SQL 2012 such as availability groups, always on, column store indexes, etc. I have not taken this exam so no NDA however they usually test fairly strongly on the new features.

    If you are only using SQL 2005 at work you are going to need to setup SQL 2012 in a lab and play with it.

    Certificates can be purchased however you will have your test score report showing you passed and what score you recieved you can also print your offical transcript from the MCP site or share your transcript online with others.


    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

    • Marked as answer by MrAndrewwayne Tuesday, January 15, 2013 4:04 PM
    Monday, January 14, 2013 8:43 PM
  • Hi,

    I wanted to add to what Sean already mentioned. Here are some links for a couple of really good books. Based on what you wrote, you may want to start with the training kit. It does a great job of covering the breadth and depth of the topics that may be covered on the exam.

    70-462 Training Kit, http://www.amazon.com/Training-Kit-Exam-70-462-Administering/dp/0735666075/ref=sr_1_1?ie=UTF8&qid=1358255750&sr=8-1&keywords=70-462

    70-462 Rapid Review, http://www.amazon.com/Rapid-Review-70-462-Administering-Microsoft/dp/0735666911/ref=sr_1_4?ie=UTF8&qid=1358255750&sr=8-4&keywords=70-462

    Also, please take a look at the following link. There have been a lot of changes to the certifcation program since SQL 2005. This link will give you more information: http://www.microsoft.com/learning/en/us/mcsa-sql-certification.aspx

    Lastly, Microsoft is currently running a promotion called Second Shot. It gives you a free retake if you do not pass the exam the first time. You do need to sign up for the program before you register for the exam.  Here is the information: http://www.microsoft.com/learning/en/us/second-shot.aspx

    Good luck! 


    Mike Corkery, MCT, MVP (Office Systems), MCSD (Windows Store Apps), MCITP, MCPD, MSF, etc. Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer”if it solves the issue.

    • Proposed as answer by Mr. Wharty Tuesday, January 15, 2013 9:30 PM
    • Marked as answer by Mr. Wharty Tuesday, January 15, 2013 9:30 PM
    Tuesday, January 15, 2013 1:21 PM
  • Thanks Sean and Mike for those responses.  They make sense and the links are useful.

    Earlier I didn't see the 70-432: Microsoft SQL Server 2008, Implementation and Maintenance.  That's what I really want as our 2005 installation is very similar to 2008.  How much longer will the 432 exam be offered?

    Wednesday, January 23, 2013 9:15 PM
  • There is no official retirement date for 70-432 that I can see however it is confusing as the other SQL 2008 exams retire 31st July 2013. Therefore if ou want the MCTS or MCITP SQL 2008 you need to complete the 432 for just MCTS plus 450 exams for MCITP by this date otherwise you can go for MCSA SQL 2008 which requires 432 and 448.

    *Note that this MCTS certification will only be awarded until July 31, 2013.
    Exam 70-432: Microsoft SQL Server 2008, Implementation and Maintenance: counts as credit toward the following certification(s):

    *Note that this MCITP certification will only be awarded until July 31, 2013. After that date, exam 432 will continue to count towards the MCSA: SQL Server 2008 certification. -

    see http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-432


    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

    • Marked as answer by MrAndrewwayne Wednesday, January 23, 2013 9:51 PM
    Wednesday, January 23, 2013 9:38 PM
  • Perfect! 

    Now I have a direction and am motivated to beat the deadline. :-)

    Thanks Sean. 

    Wednesday, January 23, 2013 9:52 PM