In my 15 years of taking various Microsoft certification tests, this test is the first that actually represents day to day work. I failed it. I'm too dependent on Books Online to get all the various syntax correct. And since training tools are not out until November and I didn't have time and money for a 5 day MOC class, I didn't have a good grasp of what to expect. (poor excuse, I know). Good thing I was able to get a free second shot.
My advice: Lots and lots of hands-on study of all of the topics in the Skills Measured that Microsoft posted.
Second Shot info: http://www.microsoft.com/learning/en/us/offers/secondshot.aspx
Skills Measured: http://www.microsoft.com/learning/en/us/Exam.aspx?ID=70-461#tab2