Today I’ve written the exam 70-453 (Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008) and I’ve cleared the exam. I would like to share the information regarding this exam. While preparation I’ve searched for these information but I got very limited information on this, so I think this could be helpful for you.
Total Number of Questions
There are two sections in this exams. TS (Technical Specialist) and Pro (Professional)
- TS (Technical Specialist) – 23 Questions
- Pro (Professional) – 25 Questions
On total I got 48 questions. There is no simulation questions in this exam.
Passing Score
You need to get a minimum of 700 in both the sections, so the total passing score is 700
Total Time
Time including writing Comments – 155 Minutes
Exam time for both the sections – 125 Minutes
Exam Fee
I’ve written this exam in NIIT (APTC), Chennai, India. They have collected Rs.2400 for this exam. Unfortunately they said there is no 25% offer (even though I have offer coupon) for this exam in Chennai.
Preparation Material
We don’t have official 70-453 preparation book from Microsoft publication. Instead you can try the below resources.
- SQL Server 2008 Books Online
- Introducing Microsoft SQL Server 2008
- Microsoft SQL Server 2008 Management and Administration – Ross Mistry
- Learning Plan for Transitioning from MCITP SQL Server 2005 DBA to MCITP SQL Server 2008 (Exam 70-453)
- Download SQL Server 2008 Enterprise Evaluation Edition 180 days Trail and play with the new features
In simple I can say you need to have knowledge on SQL Server 2005 plus SQL Server 2008 New features.
Hey Now Vidhya,
Nice Post, good to know.
Thx 4 the info,
Catto
hi this is mahe,
i want some information about the certifications of .net in ASP.NET
so can u help me..plz
i want to write any certifiction on ASP.NET,sql server which one is to better to write the certification for me MCTS,MCPD,MCITP
Thankyou
Mahe.. I not sure whether you are DBA, Developer or BI person so let me give you the link where you can get details about sql 2008 certifications. Get details @
http://download.microsoft.com/download/6/3/7/6370c653-e270-4e23-9685-15043f63dcce/SQLServer2008_CertPath_Complete.pdf.
I’m not into ASP.Net and this blog is for SQL Server, so I don’t have answer for ASP.Net certifications.
Thanks
Hi vidya, throught google i found ur link.2 yrs i was working in mysql db now my job changed and got work in Sql server 2008 in production enviroment. i need details which certification i must directly write for this above mentioned exam and few tips from you regarding preparation and timelimit to complete this exam. Regards Dhiva
I have upgraded my SQL 2005 MCITP certification to SQL 2008 Certification. If you have SQL2K5 MCITP certification then you can upgrade it else you need to write SQL2K8 MCTS and then you need to write SQL2K8 MCITP . You can choose your track exam from the document I’ve given in my previous comment.
To prepare for this exam you have Microsoft press books available but I hope only for MCTS, for MCITP you can read it from BOL.
All the best
Hi Vidhyasagar,
I will be writing the 70-453 exam on 20 Nov.Can you please help with it?
Hi Srivathsani.. I have wrote this exam long back.. But I always refer you to read the Microsoft books for the exam you are going to undertake, it will cover the entire exam syllabus with wonderful examples.
Thanks Vidhya… Nice post…