Notes on SQL Server BI MCTS 70-448 Exam

Last year, I finally became certified as a Microsoft Technology Specialist for SQL Server 2008 DBA. Here are my notes from that exam along with my studying and certification prep work. As a SQL Server Technology Specialist for Microsoft, I also work a lot with customers and solutions around data warehouse and business intelligence. So, I spent the past couple of months studying up for the 70-448 MCTS exam to become certified in SQL Server 2008 BI as well. I found this one to be much tougher than DBA 70-432. In fact, it took me 3 tries to pass this exam.

Here are my reasons / justifications / excuses for finding BI 70-448 so much more difficult … And I will preclude this list by also saying that I was surprised that I needed to take it 3 times because I have spent a good portion of my career developing, architecting and maintaining data warehouse & BI solutions, yet I struggled through this one:

My background is not only in SQL Server or Microsoft technologies. I started as a developer in C/C++, Java, Smalltalk and VB. My first data warehouse projects were in Oracle 8i and my first BI projects were written in PL/SQL and used client tools like Hyperion Workspace. If you work exclusively in Microsoft SQL Server BI, you may find it more natural than I did to pass this exam.

This is all SQL Server BI. That’s a no-brainer, I know, but in my Microsoft BI solutions, I don’t necessarily spend a whole lot of time in SQL Server. I spend much more of it in Excel, SharePoint and Visual Studio.

You need to know a lot of different technologies because SQL Server is an incredibly diverse platform, especially for BI. You need to know some MDX, SSIS, VB.NET, T/SQL, SSRS among others. Much of SQL Server’s BI platform came from different source and differen R&D teams and can be a real challenge to understand each enough to pass a certification exam that asks some very intricate questions.

I had actually expected that at most it would take 2 tries to get this cert. But my advice to you is that you should expect to take the exam more than 1 time to pass for your certification. A couple of reasons: 1) don’t get your expectations too high so that you don’t get too disappointed or disallusioned if you don’t make it on the first try and 2) I know a lot of very, very good DBAs & BI architects that work on the Microsoft platform exclusively more that I have and they struggled through 2 or 3 tries at these certs. So study but don’t get down if it takes a few tries. Even the best can struggle with cert testing.

Just like in my recommendations post for 7-432 that I linked to at the top of this entry, I recommend the Microsoft Press book study guide as a necessary part of your preperations. Make sure that you go through ALL of the questions on the test press software from that book. There are around 200 and I went through them all until I got to about 75% of them correct before going to the exam center.

You may find my methods to be over-preparation. Let say this: I’ve now certified in my career for VB, Java, SQL Server and PMP. In my mind, being over-prepared is the best way for me to be comfortable, relaxed and prepare for success. You may find that the questions are not what you thought would be asked or they may be areas of this very diverse SQL Server platform that you just don’t work with enough to know the answers. Therefore, go through all of the book and all of the questions. I know too many good DBAs who don’t prepare like I did and they struggle with these types of exams.

BTW, interesting note: The 70-448 BI study guide from Microsoft Press is written by something like 3 or 4 authors, just underscoring how difficult it can be to pass this test if you don’t know a good deal about cubes, ETL processing, building reports and maintaining these services.

Good luck and send me your questions, thoughts and stories in the comments so that we can share them with the rest of the community!

4 responses to “Notes on SQL Server BI MCTS 70-448 Exam”

I just bought the book to study for this. I’m nervous about all that I have to study. I hope I can pass this the first time. I have no experience with SQL Server, but I do know a little about SQL (queries)

If you have no experience with SQL Server, then passing by reading the book will be very difficult. Both the DBA & the BI certs took me a few times to pass and I have worked with SQL Server for a number of years. The problem with passing certifications, in my mind, is always gaining a good understanding of the format of the exam and what is expected of you. I’ve passed certs for PMP, SQL Server, VB & Java and I found that all the experience in the world in those areas does not mean that you’ll pass a cert. At least not the first time!