Professional Development

Exam: 70-448 SQL 2008 BI Dev and Maintenance

In conjunction with my professional development plan, on June 1st I took the 70-448 exam: SQL Server 2008 Business Intelligence Development and Maintenance, which I passed. Hazzah!

With most of my SQL Server career involving SSIS and SSRS, I  felt comfortable in those areas. I have only done a little bit of SSAS, so I knew that was where my prep needed focus. I ended up using the Microsoft Press Self-Paced Training Kit as my main preparation tool. I read pretty much all of it, making sure to learn more about SSIS and SSRS tools and techniques I had not played with. For the SSAS areas, I also performed all of the hands on practice exercises. This helped a lot in making up for not having a lot of SSAS experience. Overall, I found this book to be a very good prep tool and would recommend it to others who are looking to take the 70-448 exam. Also, I found the exam had really good balance between SSIS, SSRS, and SSAS. I had heard from colleagues that the 2005 version was not as well balanced.

In passing the exam (by a much better margin than I expected), I accomplished my main goal for taking it: measuring how much I have learned in the BI space. And I picked up a new MCTS cert in the process. Not a bad day.

Now that this exam, and the prep for it, are behind me, I am digging deeper into SQL 2008 R2. I just set up my Windows 7 laptop to dual boot Server 2008 R2. I set up Hyper V and have a VM with SQL Server 2008 R2 installed and configured. Looking forward to digging in. A Sharepoint colleague also sent me the link to the 2010 Information Worker Demonstration and Evaluation Virtual Machine (RTM). I will be using that to play with the new SSRS features of R2 that related to Sharepoint 2010.

Mmmmmmmm….more learning…mmmmmmmm

4 replies »

  1. Congratulations mate. I took this back in January and agree with the comments about the balance of the exam. I am now looking for BI Dev/Consultant roles and am enjoying working in this field a lot 🙂

    Have fun with R2!



  2. Mark, Mark, Mark!
    Buddy! When I first read this, I was like–didn’t he just pass another one recently??? What can I say, I’m a little slow this morning. 😉 Anyway, I re-read and realized you’re referring to the same exam. Well–congratulations AGAIN smart guy!


  3. Thanks much, friends. I announced on Twitter on June 1, but am just now getting the blog post out the door. A little behind… hehe.