In this post, I share how I prepared for the exam and what my experience was like on the day of the exam.
Important Updates in June 2019
I passed exam DP-200 in May 2019, and published this post based on that version of the exam. In June 2019, the exam was updated:
While most of the content in this post should still be relevant, there will be some differences between my skills measured checklist and the skills measured in this updated version of the exam.
Preparing for Microsoft Exam DP-200: Implementing an Azure Data Solution
When I started preparing for the DP-200 exam in February 2019, it had just been released. There were no courses, practice exams, or books available at that time. Instead, I relied heavily on Microsoft Learn and a lot of hands-on experience.
On April 3rd, 2019, the official classroom course was released. There is also a self-paced course available on Microsoft Open edX, and all the course labs are available on GitHub. I did not take either of these courses or work through the labs because I wanted to try the new learning paths from Microsoft, but you may find the more traditional courses useful.
So! In addition to the things I did to prepare, you may also want to:
After taking a break from exams and certifications for a few years, I decided to resume studying. On May 29th, 2018, I shared my Updated Microsoft Certification Goals. A week later, on June 5th, 2018, I achieved my first goal! I passed Microsoft Exam 70-767: Implementing a Data Warehouse using SQL. Woohoo :)
In this blog post, I share how I prepared for the exam and what my experience was like on the day of the exam. While I only shared my updated goals last week, I spent weeks before that focused on studying. More importantly, I have had real experience working hands-on in projects for several years. Without this experience, I don’t think I would have been able to pass this exam – at least not on the first attempt.
By then, my goals had changed. Varigence had announced the BimlHero Certified Expert program, and I decided to put the MCSE on hold for a while. Sorry, Microsoft, Biml was just more fun! :) In February 2016, after 10 months of working on the Biml certification, I became the second BimlHero in the world.
My plan was always to resume studying for MCSE: Business Intelligence. But, surprise surprise, things changed again. My new jobs required a lot of traveling, and I even put tech on hold for over a year while working in a community-facing role. I challenged myself in different ways by speaking and delivering workshops. In short, I chose to focus on developing other skills.
We are now almost halfway through 2018 and I am finally ready to continue working towards my next Microsoft Certification. Except for the tiny little detail that I was so slow that the certification I originally set as my goal no longer exists. Hahaha! :) Instead of the old MCSE: Business Intelligence, my updated goal is…
In April 2015 I set a goal to become a Certified Expert in Biml. On February 1st 2016, I became the second BimlHero in the world – the first female and the first in Europe :)
It has been a long journey, and I have loved every part of it! Varigence announced the certification program in March 2015, and in April I decided to go for it. I was accepted into the program, and in June I attended 8 hours of advanced training. I spent the next six months working on my Biml solution. I was unable to work full-time on it due to other tasks and responsibilities at work, so I spent quite a lot of time on it at home as well. In November I completed the BimlHero Certified Expert Test, and in December I submitted my Biml solution and my case study of how I implemented the solution at work. In January Varigence reviewed my test, solution and case study, and in February I had the final code review with Scott Currie. It was very nerve-wracking having the creator of Biml go through my code! :) But I received lots of useful feedback and finally a congratulations on passing and becoming a BimlHero.
This is an achievement I’m truly proud of. I worked hard for many months and spent a lot of evenings and weekends learning and experimenting…
… well, ok, I wasn’t always 100% focused on my Biml solution when I worked during weekends :) …
…and now I’m really looking forward to continue sharing my knowledge and helping more Biml users. I’m very thankful and honored I got to speak at so many events in 2015, and I’m already looking forward to some great events in 2016 – including my first full-day Biml workshop with Scott Currie! I will also continue to blog about Biml, and let me tell you… Varigence has some super exciting stuff going on that I can’t wait to dig into and share with you guys :)