• Don't underestimate the exam, and having taken it myself I can recommend you brush up on ALL your core basics. Although it's the 'entry' exam to the eventual MCITP qualification, many of the questions made me think twice, or three times, before answering. On two of the core competencies (administration, performance) I got 100%, but I neglected another competency (security) and ... well, I won't tell you my % for that, but it was cataclysmically awful. 🙂

    Also, practice your basics. Get a dev box together and practice restores. Make sure you know how to do a point-in-time restore, and set up a box to do it for real. Swallowing the books does help a bit, but you'll need a really sound knowledge of the core concepts in practice, too.

    Mike Hotek authored the original course book for 70-432, published by Microsoft. Personally I'm not happy with the number of errors in there (MS published an 'errata' doc with 5 pages of corrections) and I can attest that the sample questions do not resemble the exam in the slightest, but it does give a broad overview of all the areas you'll need. If you get the book you'll also get 15% off the exam price through ProMetric, so it nearly pays for itself.

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.