This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/
This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2007/11/15/mcts-i-passed-the-70-445-exam.aspx
Congrats on passing the exam!!!! :) . i am also planning to appear for this exam. any suggestion for me from ur experience?. Also is there any practice test for this exam?
I suggest you buy the Training Kit book from MS Press. You can find a link to it above in the blog.
The Training Kit also contains loads of practice tests. If you want more practice tests I advice you to buy the 70-445 certification tool from ExamInside (www.examinside.com)
Good luck :-)
Can any one disclose the questions faced in the exam.
will Studying 70-445 Training Kit be enough to crack the Exam?
If you study the training kit well it should be enough to pass the exam. In the training kit you will find practice labs on the end of each chapter, make sure you do them all. Of course it's also important to do a lot of practise exams.
ya im trying to do the Practise Scenarios but dont know where to find answers or what to do if i get stuck with some question....
There are no answers for
the practise scenarios that you will find at the end of each chapter. But I
think you don't need answers, the practise scenarios are not difficult because they
are hands-on labs style; you will be exactly told what to do.
I do know that you can find
some completed solutions in the installation directory of the training kit. I don’t
know if you can find all the solutions there tough.
Congratulations on cracking the exam.
I've got another question: provided you're feeling quite comfortable in 2005 general dev and have pretty strong practical SSIS knowledge however virtualy no experience in SSAS (only theory) and limited SSRS experience;
what chances do u think I've got with this exam?
In other words - is just studing the MS Kit and doing included exercises will be enough?
I think studying the TK and doing all the included exercises CAN give you enough experience to pass the exam. The exam is really focused on theoretical details, so everybody have to study for it.
When I took the exam I had quite some experience with SSIS and SSAS but not much with SSRS. I scored 100% on SSIS and something like 40% on SSRS.
So experience does, of course, matter.
SSAS is an important part of the exam so I would like to advise you to try and get some practical experience with it first. I think only SSIS experience will not be enough.
I hope this helps you :-)
I just passed the 70-431 and have been looking into the 70-445 (want to get it done in march).
I don't have much BI Experience ... i do have a lot of SSRS and a fundamental amount of SSIS experience.
I know that Adventurworks has both OLTP and an OLAP databases - are there labs/tutorials out there that leverage the OLAP database for reports, MDX etc.!?
I also noticed that in some of the MOSS 2007 webcasts that they used a Sample Portal, Reporting Service (fully populated with MANY reports) and BI tools in their Sample Portal. I've searched and searched but can't find this Sample Portal's DBs anywhere - does anyone know if they are available and where to get them!?
P.S. Sorry Jorg if I've violated blog rules by posting my email.
P.P.S. I have found numerous instructional webcasts out there on all SS2K5 Services - make sure to use them too - it's well worth it to add 10 hours of watchin' videos to your study regimen.