Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Passed 70-448! Expand / Collapse
Author
Message
Posted Monday, June 1, 2009 12:46 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:47 PM
Points: 165, Visits: 380
I passed the 70-448 exam for the MCTS: Microsoft SQL Server 2008 Business Intelligence Development and Maintenance certification this weekend. According to the MCP numbers, I’m now around person #334 certified for this exam. I hope this information helps anyone else preparing for certification.

Exam basics: 50 questions, 120 minutes, 700 passing score
This exam covers Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
On my exam, all questions were either multiple choice or select the best two answers. I didn’t have any questions that required ordering steps in a process or “select all the correct answers”.

Background: I have 13 years experience in IT and earned my MCDBA on SQL Server 2000 five years ago. I skipped the SQL 2005 certifications, but wanted to add a fresh SQL 2008 certification to my resume now that SQL 2000 is looking pretty old. I’ve worked with SQL Server 2008 since February on a data warehousing team.

Preparation resources: I primarily used the Microsoft Self-Paced Training Kit book along with installing the evaluation edition of SQL Server 2008 on my home PC. The Training Kit book is like other Microsoft Press certification books I’ve read. It’s lacking in details but gives a good overview of the topics. To fill in the details, I used SQL Server Books Online (BOL) along with these reference books:

Professional Microsoft SQL Server 2008 Integration Services

SQL Server 2008 Analysis Services Unleashed

SQL Server 2008 Reporting Services

The Microsoft Training Kit also included a practice exam with 201 questions from MeasureUp on the CD that was in the book. This practice exam was OK, but neither the Training Kit book nor the included practice exam prepared me enough to pass the exam. I purchased a 30-day online subscription to the Transcender practice exams for this certification and the flashcards and three practice exams from Transcender were excellent. However, because this is a low-volume exam, it seems they recycled some material from the SQL 2005 practice exams. The Transcender exams allowed me to focus on the details that were important for the exam and their explanations and references for each question were outstanding as always.

I prepared for about 5 weeks before taking the exam, but I could have used another week to study SSAS which was my weakest subject.

The exam started out very difficult but seemed to get easier as I progressed through the questions. I marked five questions for review and after reviewing those questions I still had 30 minutes to go back and double-check every question on the exam before my two hours was up. I didn’t have any “new format” questions like ordering steps or completing a dialog box but there were quite a few questions where I had to study an exhibit to answer the question.

The questions jumped around from SSAS to SSIS to SSRS instead of ordering the questions in blocks with SSIS first, SSAS second and SSRS third. Sometimes this required me to re-read the question a few times to be sure I was focused on the right topic (was that a SSIS role or a SSRS role?). The exam really seemed to hammer on a few topics and I began to double-guess myself when it seemed like three SSRS questions in a row all should be answered with the same config file name. In the end I passed with an 842 so I am happy to be certifiable. (pun intended) Once my transcript gets updated I plan to order the new certificate for my wall and download the new logo for my resume.

Now I’m going to take some time off and enjoy the summer! Maybe I’ll tackle an Oracle 11g certification in the fall. Good luck to all those preparing for certification…



Post #726910
Posted Monday, June 1, 2009 1:17 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:56 PM
Points: 31,168, Visits: 15,612
Congratulations, and thanks for the information.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #726930
Posted Monday, June 1, 2009 2:41 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
Grats and well done!

And, of course, thanks for the information. Very good write-up, without being any sort of brain dump or anything. That's good.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #726987
Posted Monday, June 1, 2009 2:42 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 19, 2011 2:16 PM
Points: 114, Visits: 193
Congrats!!!!!!!!!! Very useful Information. Thank You.
Post #726989
Posted Tuesday, June 9, 2009 7:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 7, 2009 7:18 PM
Points: 1, Visits: 11
Thanks, It was very informative.
Post #731984
Posted Thursday, June 18, 2009 12:30 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 12, 2014 11:45 AM
Points: 336, Visits: 867
Congrats..!!
Thanks for the information

I have to take exam next week.

Let me know if you have some study material...
Thanks



---------------------------------------------------

Thanks
Post #737825
Posted Thursday, June 18, 2009 11:49 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 24, 2013 1:55 AM
Points: 178, Visits: 465
Congratulations and thanks for the information.I believe new exam takers will benefit from your reviews and from your studies.

Eralper
Microsoft Certification Exam Blog


Eralper
SQL Server and T-SQL Tutorials and Articles
Microsoft Certification and Certification Exams
Post #738063
Posted Saturday, June 27, 2009 9:14 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 12, 2014 11:45 AM
Points: 336, Visits: 867
Thanks for the information,
I went for the exam today and passed with 899 marks...........

This is my first certification......

Very Happy to be an MCP...................



---------------------------------------------------

Thanks
Post #743210
Posted Wednesday, July 1, 2009 8:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 7, 2012 9:08 PM
Points: 2, Visits: 10
Hello Everyone,
I just joined this forum because of my interest in database field.I am a student and taking one of the class about Data mining and Warehouse. All the answers on the fouram are very useful.Specially Mr.cppwiz information is very important for me to prepare myself in future certification exams along with other exams.Thank you so much sharing the information.Have a wonderful summer!

Jalpa
Post #745418
Posted Sunday, July 5, 2009 11:43 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 24, 2013 1:55 AM
Points: 178, Visits: 465
Congradulations,
Your exam mark is very nice.

I hope you will go on taking exams :)

Eralper
T-SQL Programming


Eralper
SQL Server and T-SQL Tutorials and Articles
Microsoft Certification and Certification Exams
Post #747512
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse