Just passed the 70-461 SQL Developer Exam Today.
This exam is much harder than I expected.
Its quite syntax heavy, and asks a lot of questions on correct syntax, things that if SSMS didnt like the syntax it would take 30 secs to g00gle the proper syntax. Syntax memorization isnt a real test of knowledge IMO but regadless, its in the exam. correct syntax on index creation, table altering, view creation, grouping, xml, windowing, xml, xml and more xml all came up.
Lots of XML, know the different ways to convert rows to XML, and the differences between those ways to get xml out of tabular data.
Know your windowing functions well.
Know grouping very well.
Know UDF's well, different types and syntax.
Types of triggers and their usage.
Pretty much everything that the exam covers came up so not many shortcuts.
I used the microsoft training book as prep. book is great, but the sample exam is worse than useless. I wouldnt use it AT ALL if doing this again.
Best of luck to all taking this exam.