Im working through this: http://www.amazon.com/Training-70-461-Querying-Microsoft-Server/dp/0735666059

It's pretty good.  Comes with a CD with 200 sample questions as well to help you prepare.  That said - I haven't done the exam yet - maybe I will fail!  

Passed 70-461 few months ago. Watch Microsoft Virtual Academy video tutorial (Querying Microsoft SQL Server 2012 Databases Jump Start). If you do not use SQL Server at work, practice a lot. Use, this forum to solve problems. I would suggest go through old posted problems with answers, so you can match your answers. Practice is the key mate. One advice - please do not cram question dumps. You will not learn anything.

Also, book your exam, if you have not done so already. So, you will have a target.

Good Luck

Ronnie

Agree with Ronnie, here is the link:

http://www.microsoftvirtualacademy.com/training-courses/querying-with-transact-sql

This course can help you prepare for much of it.

can anybody share good resources to pass 70-461 2014 sql server test..

Having cleared 461, 462, 463, I'd tell you how I prepared.

- First go through the exam details at below and check the contents. MSDN URLs are provided, read all articles.

https://www.microsoft.com/learning/en-in/exam-70-461.aspx

- Check the Jumpstart video given within Self pace training.

- If you have hands on experience, 461 is really easy or else you must practice it. Follow this T-SQL forum.

All the

can anybody share good resources to pass 70-461 2014 sql server test..

Having cleared 461, 462, 463, I'd tell you how I prepared.

- First go through the exam details at below and check the contents. MSDN URLs are provided, read all articles.

https://www.microsoft.com/learning/en-in/exam-70-461.aspx

- Check the Jumpstart video given within Self pace training.

- If you have hands on experience, 461 is really easy or else you must practice it. Follow this T-SQL forum.

- And yes, you need to know the what type of questions answers there are (Drag and drop/multiple choice etc..), so you need to go through few dumps. Below is one site you can go through:
http://www.cipt2.com/category/microsoft/70-461-dumps/

Be careful and don't rely on answers provided there. Try to find out the answers by yourself.

All the

can anybody share good resources to pass 70-461 2014 sql server test..

Having cleared 461, 462, 463, I'd tell you how I prepared.

- First go through the exam details at below and check the contents. MSDN URLs are provided, read all articles.

https://www.microsoft.com/learning/en-in/exam-70-461.aspx

- Check the Jumpstart video given within Self pace training.

- If you have hands on experience, 461 is really easy or else you must practice it. Follow this T-SQL forum.

- And yes, you need to know the what type of questions answers there are (Drag and drop/multiple choice etc..), so you need to go through few dumps. Below is one site you can go through:
http://www.cipt2.com/category/microsoft/70-461-dumps/

Be careful and don't rely on answers provided there. Try to find out the answers by yourself.

All the

Hi,

I have passed 70-461 last week. I have used the official microsoft book: training kit 70-461 also have a look at the Microsoft Virtual Academy as mentioned it early anwers.

See below link for example of the book:

http://www.amazon.com/Training-70-461-Querying-Microsoft-Server/dp/0735666059

I would advice you to use official training material instead of dumps. There are official practice exams, when you buy the book there is also a voucher of measure-up in it. Maybe that will help you preparing for this exam. This way you can see the subject that are covered. There is also a cd with a practice exam in the book, those subject and quetions are nothing compared the official exam. Therefore please do not think that if you get a good score in that exam that the official exam will be like that exam.

Good luck!

Reshma

if it helps,

Microsoft has free second shot offer till end of may 2015 on certain certifications. 

i believe, sql 2012 certifications are covered in that offer.

so, even if you fail your first attempt, you can get a second shot at no cost.

Hi,

I can confirm Stan210 anwer, SQL 2012 is also coverded in the second shot.

Regards,

Reshma