Passed 70-448!

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Career » Certification » Passed 70-448!

155 posts, Page 1 of 16

1 2 3 4 5 »»»

Passed 70-448!

Rate Topic

Display Mode

Topic Options

Author

Message

cppwiz

Posted Monday, June 01, 2009 12:46 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:05 AM
Points: 163, Visits: 356

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

Steve Jones - SSC Editor

Posted Monday, June 01, 2009 1:17 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 2:36 PM
Points: 31,432, Visits: 13,743

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

GSquared

Posted Monday, June 01, 2009 2:41 PM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:55 PM
Points: 15,442, Visits: 9,571

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

Ashu Mozh

Posted Monday, June 01, 2009 2:42 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 19, 2011 2:16 PM
Points: 114, Visits: 193

Congrats!!!!!!!!!! Very useful Information. Thank You. Smile

Post #726989

rrmsud

Posted Tuesday, June 09, 2009 7:49 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, August 07, 2009 7:18 PM
Points: 1, Visits: 11

Thanks, It was very informative.

Post #731984

Learner1

Posted Thursday, June 18, 2009 12:30 PM

Old Hand

Group: General Forum Members
Last Login: Today @ 11:25 AM
Points: 323, Visits: 803

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

Eralper

Posted Thursday, June 18, 2009 11:49 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 01, 2012 6:49 AM
Points: 178, Visits: 463

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

Learner1

Posted Saturday, June 27, 2009 9:14 PM

Old Hand

Group: General Forum Members
Last Login: Today @ 11:25 AM
Points: 323, Visits: 803

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

jppatel

Posted Wednesday, July 01, 2009 8:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, April 07, 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

Eralper

Posted Sunday, July 05, 2009 11:43 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 01, 2012 6:49 AM
Points: 178, Visits: 463

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 »

155 posts, Page 1 of 16

1 2 3 4 5 »»»

Permissions