Two Sides of the Coin[UPDATE]: If you are interested in passing the Microsoft AZ 900 Azure Fundamentals Exam, check out my blog post here.
I know there is a stigma about certifications. Pros and Cons.
- Certifications are too costly
- Easy to cheat
- Does not mean much without real world experience
- Does not reflect what really happens in the real production environments
- It’s great to get your foot in the door (for someone starting out)
- Validates what you already know (hopefully)
- Can create advancement opportunities (imagine an MCSE vs someone who doesn’t have a cert)
I actually agree with both sides. It all comes down to your intentions. If you are okay with lying/cheating to get a certification, then that’s your prerogative. If you want to get a certification to move up in your career or just prove to yourself that you can get a certification…that’s cool.
How I Studied and Passed Exam: 70-764 Administering a Microsoft SQL Database Infrastructure
First, I read through this book by Victor Isakov (b | t)
(Note: If you read the Amazon (purchase the book) reviews on this book, they mention syntax errors, etc. I do agree. The book does have some errors in code examples, etc. but remember this: you should know a lot of these concepts before getting this book. This book isn’t intended to TEACH you. It’s intended to give you a “low-down” on what could possibly be on the exam. So regardless of the errors in the book, I thought it helped a lot.)
Second, I purchased the practice exam questions offered by Mindhub here. This gave me a 30 day access period to the exam questions. It provides 150 questions spread over 4 different tracks. You can do a single track at a time if you want. So if you want to focus on HA/DR then you pick those questions, then go over them. See below:
- Configure data access and auditing – (30 questions)
- Manage backup and restore of databases – (28 questions)
- Manage and monitor SQL Server instances – (61 questions)
- Manage high availability and disaster recovery – (31 questions)
One thing I will say is you need to understand the concepts and have working knowledge of the technologies listed in the simulation exam. You cannot just memorize the questions/answers.
The simulation exam has two options to choose from: practice or exam. The practice can be timed, not timed, choose 1 of 4 tracks, limit the questions it asks, see the answers before you submit, etc. The “exam” mode is timed just like you’re taking the real cert exam. The only difference is you need to pass with an 80% from 50 questions.
The real Microsoft exam is 50 questions with a passing score of 700.
The way Microsoft asks exam questions is different now. Their multiple choice questions have 8-10 options. They have mix/match/rearrange scenarios that have like 5-8 options. Not all the questions are like that, BUT, if you don’t know your stuff…you can fail this exam miserably. I understand why Microsoft is doing this: to prevent cheating.
Regardless, the exam simulation actually helped me a LOT. It helped getting my mind right and not to expect any surprises. See, the last certification exam I took was back in 2012 (MCITP 2008). Back then, Microsoft had fairly simple questions/answers. If I didn’t know that before taking the exam, I probably would have “freaked out” and failed out of nervousness.
Third, I schedule the exam 3 weeks out the same day I purchased the simulation exam. That gave me 3 weeks to study the questions, technologies, etc.
Test day is always nerve racking. I got to the testing center 15 minutes early. The exam questions were just like the simulation practice exam. None of the 150 questions in the practice exam were in the real exam. Like I said before, you need to know the material. There were 50 questions, and the passing score is 700. There were all types of questions with many multiple choice options, scenarios and a fair share of “regular” multiple choice questions.
I passed. :) Now I’m studying for Exam: 70-765 Provisioning SQL Databases.
I don’t think I would have passed if it wasn’t for the combination of reading the book AND practicing the simulation exam questions. I highly recommend doing both if you want to give yourself a better shot at passing the exam.
I hope this helps you! Feel free to let share techniques you used to pass cert exams in the comments below.
72 Replies to “How I Studied For, and Passed, Exam: 70-764 Administering a Microsoft SQL Database Infrastructure”
Really excellent content
Hi Mohammed, I am working towards becoming a SQL DBA. Please are there materials, websites that you know that can help a newbie like me?
Hey Mohammad, passed 70-764 today with 813. This post really helped me.
Congratulations! I’m glad the blog post helped! :)
Hey Mohammad I passed today with 865, first time doing a Microsoft thought this was a great blog to come back to and see how other people have found the exam over time. Also felt good knowing others were doing the same thing. If it helps anyone to know the exam i did had a total of 46 questions, some were worth 2 points, there was 2 hours to answer all, if you want to review a question at the end be sure to select this most questions offer this as an option but a few don’t. Anyone think there will be a sql 2017 or 19 exam soon i haven’t seen one yet
Congratulations Tom! That is great news! I don’t know about SQL Server 2019 certs yet. It just came out in GA recently so I am guessing….maybe some time in 2020.
Passed 70-764 with 865 points today. Damn that test was hard.
I pass exam 70-765 provisioning today, it took me a weeks to study, I went throughout the book one time, there are many error and things are not well explained, like deploying SQL using azure resource manager template, The one in the the book he refereed to VM with windows server and SQL per-installed but template in the exam are in JSON format. Sorry my engilish
Congrats my friend!
HOW I PASS WITHOUT A BOOK OR MEASUREUP
I watched videos by Aaron Sampson, he explain everything, when i was going through the book i realize that everything was explained in the videos thus why i didn’t bother. I went through first top 120 dumps on https://www.examtopics.com/exams/microsoft/70-764 , from 120 up most of the them are for sql server 2012-2014, Some exactly question came from there. I almost fail due to it was my first time writing international exam, i left some question to come review them late (but I ticked them) i happen to click finish and it took me back from the beginning, I was having 35 minutes to review but when i click finish they reduce it to 10 minutes and I cant change anything anymore. There were some error, there was a drag and and drop that require 4 drop but there were only two space and one question I tick the correct answer but when i went through for the last time it was ticket at the wrong answer and time was moving fast. writing provision next week. THANKS FOR THE BLOG ALSO HELP ME
Do you mind pasting the link to the video?
I am writing tomorrow at 11:00
July 2019, Anyone used ete file from https://www.prepaway.com before or took exam this month or last month?
Did you take the 70-765 Microsoft Cert?
Not yet. Plan on it this year. :)
Mohammad!! You are a life saver. I gave my first certification 70-764 yesterday and passed with score of 803.
Thank you so much for this post, this post helped me to get into right path. I would suggest to read the book, that is like bible.
Ha! I’m glad you passed!! :) Congratulations!
I passed 70-764 today with 855 points at the first try – and with ~15 years expirience as Dev and Admin I still Had to learn several weekends. I can confirm everything that Mohammad said about 70-764.
thank you for sharing this experience with all the community,
i stumbled into this link : https://www.mssqltips.com/sqlservertip/4696/exam-material-for-the-microsoft-70764-administering-a-sql-database-infrastructure/
and thinking of only is doing this as i use in a regular basis for work as well .
does it cover everything that would be in the exam ?
You’re welcome Vincent. I came across that link as well. I think that link provides MORE information than needed to pass the exam. My post focuses on the exam topics.
From that link, hope you don’t mind pointing out which topic/s listed should I put heavy focus on? Thanks a lot in advance.
I did the same. Got the book read it twice did practice questions twice. Passed 764 first time 830 out of 900. Used same strategy with 765 got similar score. Didn’t bother with dumps waste of time. Questions are too difficult to rely on dumps I think. I found the questions difficult though and some questions on topics not covered in the books. There are errors in the books and they really ought to be corrected in PDFs but are not.
I would like to learn about this subject and also take the certification exam.
My challenge is i have absolutely 0% knowledge/experience with SQL or DBA.
Where/what resources can i start from in studying, before eventually using the exam preparation materials to prepare for the exam?
Remember I am an absolute novice.
Feel free to contact me directly via the contact page. Answering these questions would take a lot more than what can be typed here. I’d be more than glad to answer them via email.
You don’t need to think much before going for a difficult exam like Administering a SQL Database Infrastructure because now you have 70-764 exam dumps for your preparation and now you can easily ace your exam. Experts have done their best to help the students according to the exam type. You can practice your knowledge on testing quiz and can bring definite results by your efforts. You can contact us anytime at Dumpsprofessor. Our representatives are always available for your help there. https://www.dumpsprofessor.us/microsoft/70-764-braindumps.html
I would second you here mate, you have to know your stuff. I just passed this exam today.
I was expecting a lot of questions from practice exam but there were hardly 4 questions out of practice exam.
I read the Ref book like 5-6 times and I think that was the only way for me to pass this exam.
One thing which bothers me is that some questions in the exam, they don’t relate to training material at all. You have to be an experienced DBA with strong T-SQL skills to answer these questions.
Anyway, best of luck to others attempting this exam.
Hammad, Congratulations on passing! It was a little nerve-racking when the questions didn’t fully line up with the book/exam material. You definitely need to understand basic concepts, code, etc. to pass!
70-765 passed now! i got my MCSA! onwards now on MCSE with 70-762 ..thank a lot to this blog’s post that leaded me in the right Learning path.
Congratulations man! Glad the blog post could help! :)
here i am! today i passed 70-762 with 816 points and i got my MCSE: Data Management and Analytics! now i study 70-761 to achieve MCSA DATA DEVELOPER ! T H A N K S to this post!
Congratulations man! I’m glad this post was helpful!
Hello! I want to preparation for this Exam 70-764. Can anyone tell me frrim. Where i get material or dumps?
Pls check quora many answered for your questions
Links are in the article :)
Hi Mohammad, Thanks for your feedback. I’m a Sys-admin and want to fill gaps with no experience previous experience in DB administration. Would this be a good exam to start with or would you suggest a different resource first as a warm-up? I feel like without the core concepts of DB administration, it’s a little difficult to get started with the exam-ref book.
Hey Byron, you’re welcome! You are correct. I would not recommend diving into this book if you don’t have experience in SQL database administration. I recommend learning the basics like how SQL Server does backup/restores, indexing, etc., then move into the exam books. Let me know if you need any referrals to great course content and I’ll be more than glad to send them to you.
I pretty much followed your advice and just passed today.
scored 780 .
I got a practice exam too and like you said format is good but questions are a little ridiculous.
One other thing i did was get the udemy course on 70-764.
Great course but not much of the content is in the exam. Still good to get your head in the right space
Congratulations!! Glad this post helped!! :)
fingers crossed Mo!
Let us know when you passed! :)
Just passed with 813 points :-) Onwards now to 765.
Awesome man!! Congrats! I’m sure it feels great! 🙂
Yeah pretty chuffed, thanks for the blog Mohammad! Its really useful to hear of others experiences.
My pleasure buddy!
My primary form of study was Lynda.com’s Administering a SQL Server Database Infrastructure video course. It covers all the topics you’ll see on the exam and breaks them down into small 3-8 minute videos. There are also exercise files you can download as well. I would highly recommend it. I’m going to use their course to study for 70-765 as well.
Thanks Stephen. I checked out the Linda video called “SQL Server 2016: Provision a Database.” I was surprised that the trainer set the auto file growth to percent. Stopped watching after that. :)
The videos aren’t perfect, but the format is excellent. It also covered everything I needed to know to pass 70-764 with a score well above 700 and this was literally the only study tool I used. I’m going to use the same approach for 70-765 and see how we go. :)
The one thing about the 765 exam are the service tiers. I contacted the author of the book I am using and he said to learn the service tiers online. Not the book (since they are outdated). For example, Premium RS no longer exists. So keep an eye out for that in the video as well.
There were no vCore service tier questions in my exam surprisingly.
Thanks Stephen, I think I’ll use these videos alongside the Victor Isakov book and practice Qs that Mohammad used.
Cover all bases :-)
If you did that Will, you’ll definitely pass the exam with “flying colors” :)
Hi Mohammad, thanks for sharing this, I’m currently studying for the same exam and getting a little frustrated at the granularity of some of the practice Q’s
e.g. which permission do I need to grant to a user\role to do x or y?
I mean come on… there are sooo many permisson levels, I would just refer to a matrix in SQL BOL or technet. Its usefull to know the options exist but you’re never going to remember all of these permissions.
Still its good to know we’re all gone or going through the same thing :-)
Yes, I agree. The amount of “granular” questions they ask in the practice exam is ridiculous. No one knows all of them by heart. What I did was just learn/memorize the ones that easily came to me.
Also, don’t forget…you just have to pass with a 700 :)
Thanks Mohammad, I’ll remember that, it will prevent me from pulling, what little hair I have left, out!!
only joking, I’m quite enjoying the learning process.
Hi Mohammad thanks for sharing your experience. I would like to know one thing :the passing score is 700 on a maximum of? 800?1000?
Hello Antonio, I think it’s out of 1000.
Thank you! just a last question: you got a mindhub test. i ‘am planning to get a measureup test (because it’s available the download option) , i don’t understand if they are the same test or it’s better mindhub.
Welcome. I have the MeasureUp exam access. I bought the 30-day access one.
Exam passed just now with 896!
Awesome man!! Congratulations!
Antonio / Mohammad, have you used MeasureUp? Does it help a lot or almost nothing? Are there any question on official TEST? Thanks!
I used Mindhub and it looks similar to MeasureUp. I chose Mindhub because it’s what MS recommended on their site. But regardless if you go with Mindhub or MeasureUp, I didn’t find much questions on the exam that were straight from the practice test.
It’s 900 no?
Hi Mohammad Darab,
Could you tell me, how many questions do we have correct answers to pass this 70-764?
It’s hard to tell. Every question is weighted differently. There are a total of 50 questions, and depending on how many questions you get from each of the 4 topics…can calculate the final passing score differently.
Aim to get all the questions correct and you should be fine! :)
Hi Mohammad, thanks for sharing your story! I’m planning to take the exam end of April and am approaching the exam same way as described, congrat on passing this way!
Few questions I have:
– Do u get a sense the focus of the question mainly went to functionality that was introduced in SQL Server 2016 (like query stores, etc) or not really?
– I remember from the older version of this exam, that some questions have a large intro/scenario and u just had to decide if u agreed with the suggested approach (i.e.: Yes/No answers), do those still occur too? Or is it only multi-multiple answers throughout the exam this time around?
Thanks for the comment. To answer your first question; yes. You’ll have to know about distributed AGs, query store, etc. If you plan on getting the simulation software, you’ll see a lot of 2016 features on there.
To answer your second question; No. They did have numerous scenarios…quite lengthy, then instead of a “yes/no” choice…they give you 4-6 choices. It makes it more intimidating (at least it did for me), but just remember to go over the simulation exam questions as much as you can until you start scoring 90%+ on every attempt.
Hope that helps and good luck man!!
Thanks for sharing your experience. It’s interesting to hear how others prepare and what worked for you.
You’re welcome Bert!