Hurray, I passed 70-761! That means you can too!
I just thought I’d share briefly how I passed the exam. As a note, the below is how I studied and what I studied, it may or may not be what was on the exam as they change the exams and I cannot discuss what was on the exam directly. Nor can I answer any specifics to the exam, you can find all of this information on Microsoft’s website. I am going to share however, how I got to the point to where I felt comfortable taking and then passing the exam.
I thought the 70-761 was hard but fair, it was both easier and more difficult than I expected it to be. There were three key aspects for me that I’ll apply for the 70-762 exam that helped me to succeed. Figuring out when to schedule the exam, how to study for the exam, and how I should think and answer the questions during the exam.
To schedule the exam, I broke out every topic covered in the description of the test and decided between the things I needed to learn, review, and skip. I then also broke down how much reading and how long each reading session would take. I gave myself an estimated time period for each of the topics I had to learn/review and kept a notebook tracker with the topics, days until the test, and how much reading was left. Based on how much time I thought it would take to learn, I allocated myself 30 minutes of time to study per day and divided by total time I thought I would spend studying by that, and scheduled the test out that many days. Some days I was able to study for 30 minutes while some days I couldn’t study at all. Other days like weekends, I could double down and put in a few hours at once. I would also record what I studied on what day with what resource and about how many hours I put into it.
Scheduling the exam got the fire under my rump to get me moving and motivation. If I didn’t spend the time studying, I’d walk out humiliated and short $160 with a longing regret of what I could have accomplished. So by finding the amount of time I needed and allocating that time for myself to study, I scheduled the exam for 50 days out for 2018-12-08! By actually scheduling the test, I was no longer able to procrastinate, it was now a priority.
On the same page of studying, make sure to study smart. Don’t spend two hours watching videos on joins when you have that down. Spend the time on things you are either unsure of or don’t understand. Topics that you are 100% sturdy on may not be bad to do a brief review to see if you missed anything, but I wouldn’t dedicate more time than reading a chapter in the 70-761 study guide.
For study material, I read the entire 70-461 exam prep book and then read specific sections in the 70-761 exam prep book. Especially on the XML / JSON / Temporal tables, I had heard you need to focus heavily on this from other forums. One note I’ve read is that Microsoft likes to really drill you on things that were new to the version of SQL you are testing for. So I focused heavily on studying things that were new from 2014 to 2016. I read most of and skimmed some chapters in the book T-SQL Fundamentals.
I used additional resources from Cathrine’s websiteand MS SQL Tips. I reviewed the XML stairway serieson SQL Central and also watched every video that is recommended on the links I am providing.
JSON and Temporal tables were hard to find good resources for. I ended up reading the entirety of the MSDN tech notes on Temporal tables. I found learning XML and JSON the easiest by practicing problems I’d think of in Adventureworks, otherwise only reading the material did not stick as well. Anything I haven’t used regularly I made sure to read on, watch videos, and practice. I would also search stack overflow for problems associated to topics I wasn’t clear on and try to solve them or at least read up on them. If you aren’t feeling overly confident in an area, try looking for another online resource. If you can find sites that can test your knowledge in areas, that is a fantastic approach to realizing what areas you are lacking in information. Being able to explain something to someone is also a good indicator of how well you understand something.
I would also listen to podcasts and videos while running each morning, but I honestly don’t think that helped much for the test. For topics I found the hardest, I’d start by reading the prep chapter in the exam book. Then I’d look for some reputable and good videos on the topics, read an additional online blog or two, and then I would create practice problems. If I still felt unsure, I’d look for a podcast on the topic to listen to loosely during a free time like driving or running, and then I would also look for flash cards and quizzes online. The most beneficial study tool was using technology day in and day out, otherwise the 70-461 and 70-761 exam books were my bread and butter. Quizzes and flashcards helped me a lot to identify the areas I needed to focus on learning again.
Everyone else has said this about the test but I’ll say it too.
Use your test taking abilities.
If you can go back to a question that is taking you a long time, mark it for review and continue with the test and go back to it at the end. I used every second of the 2 1/2 hours of the exam. I don’t know if having more time would have necessarily changed my score, but I feel 30 more min would have made me felt more comfortable and less rushed.
If you can narrow down the answers you have to pick from, do that at the very least even if you are stumped by the question. From the narrowed down answers you can at least guess.
Don’t leave any answer blank and try to answer them all.
If I were to do it again, I’d probably do more flashcards on definitions of terms in my studying and will try that for 70-762. If I were really uncertain, I’d probably take the official pre-test. I would recommend the 70-461 book just because there is so much good information inside of it, I only bought the 70-761 because it had JSON and Temporal Tables. I’d suggest you could go with the 70-761 + T-SQL Fundamentals instead of the 70-461; or you can go with the 70-461 and the Temporal Tables section in the T-SQL Fundamentals while also adding some supplemental JSON training since that is lacking in the 461 exam book. My test will probably not be the same as you will have and you need to look over the content you can be tested on via the Microsoft site for the cert. Good luck and I’ll see you on the other side of 70-762 shortly!
My favorite resources:
https://www.amazon.com/T-SQL-
http://www.accelerated-ideas.
https://www.mssqltips.com/
https://www.mssqltips.com/
https://docs.microsoft.com/en-
https://www.mssqltips.com/
https://docs.microsoft.com/en-
https://www.mssqltips.com/
