Took 462 yesterday and only managed to get 612 vs the pass mark of 700. Main problem is that I'm not a DBA so was doing everything from the book rather than based on experience. I will need to pass this at some point though (I have a Second Shot valid until the end of May).
I'm actually a Senior Developer. I came in this morning and took a practice test for 461. Fifty questions, which I rushed through in 20min without having looked at the book at all yet I still managed 92%.
So, assuming I do a quick "brush up" on 461 (Query Hints and Encryption was what I missed) is it worth taking that before the 462 resit just to get a bit of a confidence boost?
As far as 462 goes does anybody have any tips for the best way to approach this? I think I need to spend more time actually working through examples and case studies from the book but I'm still not sure if that covers everything. I won't say anything about what was in the exam but there were a couple of nasty surprises there for me.
I was hoping to get 462 "out of the way" as the other ones actually reflect what I do in my job. It's a shame that you now need a DBA qualification to get any sort of certification in SQL Server 2012.
MCSA SQL Server 2012