Skip to content

Querying Microsoft SQL Server 2012 Beta exam (70-461 / 71-461) – My Thoughts

April 13, 2012

Well I’ve now done the final SQL Server 2012 exam I managed to get a slot booked for. The Querying Microsoft SQL Server 2012 exam wasn’t going to be my strongest subject as I’m more of a DBA than Developer but i felt it went quite well.
The exam consisted of 55 questions, varying in structure from multiple guess to drag n drop. There were only about 5 or 6 questions i left comments about relating to the content not being clear, typo’s or in one instance an actual mistake in the question so all in all a better setup than the Administrator exam I took first off (70-462 / 71-462).

The biggest issue I found was down to my own fault. I didn’t revise on the syntax of the new 2012 T-SQL functionality. Don’t get me wrong, I know i’ve got a lot of them right but with some, although I knew the answer was down to 2 of the 4, I didn’t know it well enough to be 100% certain as there was only 1 word different in the syntax which I’m a bit disappointed with……..but no-one to blame but myself 🙂

I’m still not sure whether the pass mark is 70% or 80% and hoping I’ve answered enough of the non-2012 questions correctly to scrape through.

As always, I’d be interesting to hear other peoples thoughts on any of the 2012 exams they’ve taken so far…..

From → Exams, SQL Server

  1. Alex Rosa permalink

    well done, I felt the same thing when I took 71-462 yesterday, some questions asking for syntax details and I didn’t know, because of the last two years I’m not supporting development teams anymore. So, let’s study more… lol…take care.

    • Hi Alex,

      Yea I’m of the same situation, the last few years my major projects have consisted of infrastructure upgrades, tuning, security – basically everything which isn’t development!

      Gonna make up for it with my current project, massive data re-architecture and re-write of overnight processing……that should bring me back up to speed 🙂

  2. Isabel permalink

    Hi Chris, I need to take exam 70-461 soon. What material did you use to study?
    Thank you

    • Hi Isabel,

      I didn’t really use too much other than looking at what topics Microsoft say will be covered and look at those on msdn as well as learning the new 2012 stuff by playing around with one of the 2012 test servers I’ve got setup at home.

      Sorry I can’t be of more help but I recommend brushing up on ALL the topics MS list and also learn the new tsql stuff in 2012 as best you can before sitting it. The toughest thing for me was not knowing the exact syntax for the new tsql commands due to not spending enough time with them.


  3. msuworld permalink

    can you guide to some samples on what are the questions like as i am also intending to take the exam but couldn’t judge my preparation level 😦

    • As part of the exam you’re bound by NDA so I can’t disclose anything regarding the specific content I’m afraid. There’s 2 options for you:

      1 – See if the likes of Prometric are still handing out the vouchers for a free retake if you fail
      2 – Buy the books available which have sample questions/tests with them
      3 – I begrudge offering this as advice but you can pay for sample questions from some websites which may give you more of an indication as to the level you’ll need to be at.

      With regards to option 3, I’m not sure all of these are accepted by MS as authentic practice material so be wary……

      Hope this helps.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: