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 website and MS SQL Tips . I reviewed the XML stairway series on 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/
Josh, thanks a lot for posting this. Appreciate the links to blogs and websites at the end, as finding useful resources is tricky.
Thanks for posting. I also found that essentialSQL’s resource page was a good help. Their study guide is awesome. Here is the link – https://www.essentialsql.com/70-761-resource-page/
Thank you. The links are very helpful.
Thanks Jon! This article is very helpful. Passed 70-761 a while ago and just passed 70-762 last week.
Good stuff here…
But, the essential sql site IS WRONG!
They have transaction and optimization sections included in the 70-761 exam. These sections ARE NOT on the 70-761 exam, but are on the 70-762 exam!
I’m not sure I would trust the information on that site.
Greetings John,
Thank you for reading, I hope it helped! Also, thank you for bringing to my attention some inconsistent material!
Microsoft has and can change the tests at any point, so it’s possible that the material changes over time. I read through the EssentialSQL Site’s study guide and compared it to the 70-761 study guide and they look pretty similar but there are differences as you mentioned.
Similar topics covered by the 70-761 study guide and EssentialSQL related to the transactions:
– What is a transaction?
– What are locks?
– Isolation level overview.
– BEGIN TRANSACTION
– COMMIT
– ROLLBACK
– READ UNCOMMITTED
– READ COMMITTED
– REPEATABLE READ
– SNAPSHOT
– SERIALIZABLE
Material that is inconsistent between the 70-761 study guide and the EssentialSQL site related to the transactions:
– Intent Shared (IS)
– Intent Exclusive (IX)
– Intent Update (IU)
– Shared Intent Update (SIU)
– Update Intent Exclusive (UIX)
The 70-762 is definitely capable of testing your skills on the types of locks in more detail than the 70-761. I think covering these lock types can significantly help with one’s understanding of the isolation levels. Really though when it comes to this material, I strongly recommend reading the entirety of Kalen Delaney’s book on SQL Locking and Blocking.
I’ve mentioned it in my post who and why should someone become certified, but I don’t think the total goal of getting certified is getting the paper. I think the purpose is the journey and quality of material and time spent studying. Concurrency in database is a very critical topic to understand and I don’t recommend skipping knowledge or training in this sector.
Here’s what the 70-761 exam says currently about the topics listed regarding transaction levels:
It’s pretty broad, but apart from the locking, I think EssentialSQL provides comprehensive material over this section.
When I look at the optimization sections, there are some stark differences. The 70-761 guide covers some optimization techniques, but it’s mostly associated to APPLY / CTE / Subquery operators. The EssentialSQL site goes significantly more in-depth and does cover topics more related to the 70-762. EssentialSQL does cover query plans and the 70-761 does have some coverage here too.
So using the EssentialSQL guide here is not a 100% match to the 70-761 material but it does segway nicely into the 70-762 exam. Overall, the material and assistance linked from the EssentialSQL site are good. I would just caution readers to use the Microsoft site to read what the requirements of the exam are, which is exactly what you did. The exam material can change, websites can be inconsistent with the exam, and material online can become outdated or incorrect over time. So it’s a great mindset to approach material you find with a critical eye. This can ensure you’re spending the right amount of time preparing for the material you’ll be tested on.
Motivational
Thanks, it was very helpfull
In how many days, the test result is given???
You will know instantly if you pass or fail and your score. Once you leave the facility, you can access your score and proof of passing online. Your badges (only for display purposes) typically take a few hours to a day or two to generate.
Thanks, it looks very helpful!
Thank you Jon for sharing with us your experience.
Could you please tell us about the format of the exam? Was it 100% multiple choices? Was there any coding? Did the exam provide us with an implementation of MS SQL?
Thank you.
Hi Minh, my apologies for the delay. I have been trying to find the layout FAQ for the 70-761 but it appears the pages have changed. Because the layout is not public information anymore, I’d recommend to either email Microsoft with the question or check out the practice test. I felt the practice test for the 762 did a good job of preparing me for the exam and I would expect the same with the 761. In general though, you will want to use your test-taking skills if there are multiple-choice or matching questions. You should know how to write T-SQL in case syntax is tested. There is no SSMS or hosted implementation of SQL Server that you are in, it’s purely a test portal.