SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Passed 70-448!


Passed 70-448!

Author
Message
cppwiz
cppwiz
Old Hand
Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)

Group: General Forum Members
Points: 324 Visits: 470
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…



Steve Jones
Steve Jones
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: Administrators
Points: 61743 Visits: 19099
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
My Blog: www.voiceofthedba.com
GSquared
GSquared
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23311 Visits: 9730
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
Ashu Mozh
Ashu Mozh
SSC-Enthusiastic
SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)

Group: General Forum Members
Points: 120 Visits: 193
Congrats!!!!!!!!!! Very useful Information. Thank You.:-)
rrmsud
rrmsud
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 11
Thanks, It was very informative.
sql_learner29
sql_learner29
Say Hey Kid
Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)

Group: General Forum Members
Points: 697 Visits: 922
Congrats..!!
Thanks for the information

I have to take exam next week.

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


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

Thanks

Eralper
Eralper
Old Hand
Old Hand (332 reputation)Old Hand (332 reputation)Old Hand (332 reputation)Old Hand (332 reputation)Old Hand (332 reputation)Old Hand (332 reputation)Old Hand (332 reputation)Old Hand (332 reputation)

Group: General Forum Members
Points: 332 Visits: 466
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
sql_learner29
sql_learner29
Say Hey Kid
Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)Say Hey Kid (697 reputation)

Group: General Forum Members
Points: 697 Visits: 922
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

jppatel
jppatel
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 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
Eralper
Eralper
Old Hand
Old Hand (332 reputation)Old Hand (332 reputation)Old Hand (332 reputation)Old Hand (332 reputation)Old Hand (332 reputation)Old Hand (332 reputation)Old Hand (332 reputation)Old Hand (332 reputation)

Group: General Forum Members
Points: 332 Visits: 466
Congradulations,
Your exam mark is very nice.

I hope you will go on taking exams Smile

Eralper
T-SQL Programming

Eralper
SQL Server and T-SQL Tutorials and Articles
Microsoft Certification and Certification Exams
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search