Exam: 70-448 SQL 2008 BI Dev and Maintenance

14 June, 2010 (08:57) | Professional Development | By: Mark V

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


Comment from Barnaby
Time June 14, 2010 at 9:03 am

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!


Comment from Bob Pusateri
Time June 14, 2010 at 9:04 am

Excellent post & contrats on passing! I hope to start studying for that exam soon myself.

Comment from Janice Lee
Time June 14, 2010 at 9:12 am

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!

Comment from Mark V
Time June 14, 2010 at 9:20 am

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.

Write a comment