Querying Microsoft SQL Server 2012
Today I passed the exam in 1st attempt.
I have a Data-warehouse and BI experience of over 3 years, which obviously helped.
Questions where you actually have to implement things you learn would be easy you have database experience.
For other questions the Preparation Kit is good enough. I had a one pass over entire book, but it was detailed one.
I would say 2 weeks of time is good enough ( if you actually sit and study on all these days )
All the best for anyone preparing for this exam !!
Kudos. I am about to take the exams. Any help from you? per say, if you have dumb on the exam.
Congratulations.. You have done good job. I am planning to take this exam in this Sep 2014 month. Could you please let me know how soon will get our results & the certification once after clearng the exam. And this MCP 70-461 certification s globally recognized right?
I also have sufficient experience with SQL 2012, but I am not confident enough to take the 70-461. Here's how I am approaching the review/study process (might take me a month):
Read Training Kit 70-461 (finish reading the book) --> Watch Pluralsight 70-461 video training (finish the video sessions) --> Take Practice Exam on 70-461 --> Schedule The Exam/Take Exam
I think that is a good route Marlon. Keep up the good work and good luck.
Congrats! I passed MTA in 1 attempt with 89%. I am planning to take 70-461. Don't have experience, but some background knowledge. Any suggestion?
Here is a good jump start from the Microsoft Virtual Academy. mva.microsoft.com/.../querying-microsoft-sql-server-2012-databases-jump-start
I would also highly recommend the T-SQL fundamentals book by Itzik Ben-Gan. www.amazon.com/.../ref=sr_1_1
Thanks, John. Appreciate it.
Follow John's leads. Very good material there.
On another token, I would like to clarify something from your post. When you say 89% I am assuming you scored around 890 out of 1000 possible points.
Keep in mind that 89% doesn't mean you've answered correctly 89% of the questions on your exam. Lets say you had 50 questions on your exam, so it doesn't mean you've answered correctly 44 or 45 questions.
Questions are weighted differently. They have distinct values. When you get 890 point it means exactly that: you've gathered 890 point of 1000 possible. It is possible you've answered correctly less than 44 out of 50 and still get a score of 890 points.
My point for our studding group is: when you go for the test don't do math based on amount of questions you feel like you've answer correctly. You never know which ones weight more or less points.
Keep it simple and make sure you (try to) answer all of them correctly, as you already do. Don't bother doing math on amount of questions. This is a big distraction while taking the test.
Just a heads up. :)