In this post I will talk about MCTS BI 2008;
Microsoft certification plan for Business Intelligence in SQL Server 2008 contains two exams:
70-448 ; MCTS (Microsoft Certified Technology Specialist) – SQL Server 2008, Business Itelligence Development and Maintenance
70-452 ; MCITP (Microsoft Certified IT Professional) – Business Intelligence Developer 2008
so if you want to get certified in Microsoft BI 2008 you can pass two exams above
Order of exams is important, you cannot sit on 70-452 before passing 70-448.
exam 70-448 may contain 55 question (more of less), in these main areas:
Implementing an SSIS Solution (17%)
Configuring, Deploying, and Maintaining SSIS (15%)
Implementing an SSAS Solution (21%)
Configuring, Deploying, and Maintaining SSAS (17%)
Implementing an SSRS Solution (17%)
Configuring, Deploying, and Maintaining SSRS (13%)
So If you have a detailed development knowledge of Microsoft SQL Server 2008 SSIS, SSAS and SSRS you can pass this exam easily.
For preparing this exam I strongly recommend this book:
This book covered all exam’s main aspects. But note that you can not just rely on this book if you didn’t worked with SSIS, SSAS and SSRS before. So if you are a novice in Microsoft SQL Server 2008 Business Intelligence you should read more books on these 3 main products: SSIS, SSAS and SSRS.
I’ve passed this exam few days ago with mark 838. Passing mark for exam is 700. and time for exam is much more than enough to answer all questions.
Note that Microsoft Certification Plan for SQL Server 2012 changed, but if you have MCTS BI you can pass upgrade exams.