InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 07:35:13 GMT20http://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxI took and passed the 70-432 exam at the weekend and there were 40 questions, seems pretty low compared to the number listed on the dev track.As study guides I used the Syngress 70-432 book and BOL.Unfortunately Microsoft do no seem to be releasing study guides for the MCITP 70-450 exam.Mon, 21 Jun 2010 07:26:30 GMTRichardDouglashttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxI'm using Self Test Software Practice questions to prepare for my 70-433 exam. When I practise in certification mode the software gives me 90 mins to complete 55 questions. Although I just completed in time all questions in that duration but could not get time to review my answers.Sun, 06 Sep 2009 02:24:33 GMTBhavesh-1094084http://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxbhavster27, the article discusses the number of questions and time. I would not worry about that though. In every Microsoft exam I have ever sat for, I have answered all questions, double checked every single one, and still had plenty of time left over. That is of course anecdotal, but I think it is safe to say that for someone who reads at an average speed time is not an issue in these tests.Sat, 05 Sep 2009 14:31:47 GMTtimothyawisemanhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxbhavster27,The information you're after is in the [url=http://www.sqlservercentral.com/articles/SQL+Server+2008/67599/]article[/url], under the heading [b]About The Exams[/b].Thu, 03 Sep 2009 09:42:01 GMTmike.mcquillanhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxThose who have already appeared for exams 70-433 and 70-451 can you please tell us how many questions where asked for each exams and how much time is given to answer them.Thu, 03 Sep 2009 00:19:15 GMTBhavesh-1094084http://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxbhavster27, I am going to echo Mike here. I have never known a certification to get someone a job, but it can definitely help in getting the interview. I know this both as someone who has gotten interviews because of my own certifications and as someone who has consciously used them as one factor when screening stacks of resumes to decide who got interviews.Tue, 01 Sep 2009 07:59:02 GMTtimothyawisemanhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxHi bhavster27,I think having a certification helps you make it to the interview stage - it's seen as a "nice to have" on your CV.Once you're at interview stage, it's all up to you...Tue, 01 Sep 2009 02:21:52 GMTmike.mcquillanhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxHow valuable your employer will consider these certs are for their employees.Does going for certs stand you apart from the crowd. Does it help in this economic climate?Thu, 27 Aug 2009 08:43:34 GMTBhavesh-1094084http://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxVery nice infos ...Mon, 24 Aug 2009 06:41:06 GMTDugihttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspx[quote][b]SanjayAttray (8/21/2009)[/b][hr]If you already had 2005 certification then most probably just write one paper 70-453 and you get MCIPT. In Database Administration though, which I cleared last year.I am far away from programming.453 UPGRADE: Transition your MCITP Database Administrator Skills to MCITP Database Administrator 2008[/quote]Hi Sanjay,Apart from practical experience with SQL 2008, what preparation guide did you use for exam 453? Microsoft says there is still no preparation guide for this exam (at least from MS Press). I doubt if they will release one :-). Was it only BOL for SQL 2008 which you referred to?CheersSun, 23 Aug 2009 23:49:09 GMTSadequl Hussain-911759http://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxHi Mike,Exellent article!! especially for those who wants to appear for exam but have no knowledge. I am going to add it to my favorite articles on SQL Server :-)Hey, can you give some guidence on 70-432? I want to appear for that. Your article is very nice for 70-433 and 70-451; Wish to have some for 70-432 and 70-450.All the best for 70-432! :-)Sat, 22 Aug 2009 00:06:47 GMTKruti Kansarahttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxExcellent article. One thing worth reemphasizing is practical experience, as mentioned in the article. You can learn a lot by setting yourself challenges and trying to solve them.Fri, 21 Aug 2009 15:06:20 GMTtimothyawisemanhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxHi PhilI hold my hands up to the error, and certainly don't think BOL is the "gold standard", though it is very good. I mention Vieira's book as I think it's useful to have a general reference book to hand, especially when studying - BOL tends to be a little dry at times.There is a 2008 version of the book out now too, but I haven't read it so can't comment.Unfortunately I cannot correct the article once published, I have no access to it. I'd dearly love to add in the missing links I posted up for the 70-451 section too.Thanks for everybody's feedback, I'll do my best to ensure no errors are made in future articles.Fri, 21 Aug 2009 14:36:17 GMTmike.mcquillanhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxMike,Good luck to your 70-432 exam.MarcoFri, 21 Aug 2009 13:26:13 GMTmchouhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxVery good article. Unfortunately when I tried to rate it , by mistake I gave wrong points :blush:I am sorry about thatFri, 21 Aug 2009 12:38:54 GMTAntonios Chatzipavlishttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspx[quote]Alexander, the Robert Vieira SQL Server 2005 book does not mention the Snapshot Isolation Level, which is why I've stated there are only four levels in SQL Server 2005. You are correct however, the SNAPSHOT isolation levels were added in SQL Server 2005. This is an error on my part. The point still stands that you should be aware of the SNAPSHOT isolation level for the exams.[/quote]But BOL states that 2005 offers the four SQL-92 isolation levels, and additionally the SNAPSHOT isolation levels. Surprising that you tout BOL as the gold standard, yet you referenced a book. ;)Is there any chance you can correct the article itself instead of simply acknowledging the error here?Thanks,PhilFri, 21 Aug 2009 11:33:40 GMTPhil Brammerhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxRe: joncooney73. I was not aware that Pass 4 Sure & Self Exam Engine (both of whom I'm pretty sure are the same company) are possibly regarded as braindumps. I don't advocate the use of braindumps under any circumstances - if you're not interested in learning about the product, don't take the exam. That said, I don't recall seeing any questions on the exams that were in the two testing engines mentioned.mchou, I am actually studying for 70-432 at the moment, using the [url=http://www.amazon.co.uk/Professional-Microsoft-Server-Administration-Programmer/dp/0470247967/ref=sr_1_6?ie=UTF8&s=books&qid=1250863874&sr=8-6]Wrox book[/url] by Brian Knight et al. Unfortunately I'm moving house too, so time is limited. I'll try to write something up on it when I eventually take the exam.Alexander, the Robert Vieira SQL Server 2005 book does not mention the Snapshot Isolation Level, which is why I've stated there are only four levels in SQL Server 2005. You are correct however, the SNAPSHOT isolation levels were added in SQL Server 2005. This is an error on my part. The point still stands that you should be aware of the SNAPSHOT isolation level for the exams.Fri, 21 Aug 2009 08:14:23 GMTmike.mcquillanhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxThe following is incorrect:"One warning - if you buy a SQL Server 2005 book, ensure you consult Books Online after reading through a subject. For instance, there are only four isolation levels in SQL Server 2005; SQL Server 2008 has added the SNAPSHOT isolation level"Two SNAPSHOT isolation levels were added in SQL 2005.Fri, 21 Aug 2009 07:59:51 GMTAlexander Kuznetsovhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxIf you already had 2005 certification then most probably just write one paper 70-453 and you get MCIPT. In Database Administration though, which I cleared last year.I am far away from programming.453 UPGRADE: Transition your MCITP Database Administrator Skills to MCITP Database Administrator 2008Fri, 21 Aug 2009 07:38:38 GMTSanjayAttrayhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxThank you for sharing.Do you have any insight on SQL Server Administration - 70-432?Fri, 21 Aug 2009 07:20:06 GMTmchouhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxPass 4 Sure & Self Exam Engine are suspected to be brain-dumps by [url=http://www.certguard.com/]certguard[/url].Fri, 21 Aug 2009 04:10:21 GMTJon Cooneyhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxHi allI'm not sure why but none of the links for the 70-451 section have been generated correctly. Here they are, sorry for the inconvenience:[url=http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-451]70-451 Preparation Guide[/url][url=http://msdn.microsoft.com/en-us/library/cc716779.aspx]Entity Framework Microsoft Article[/url][url=http://www.mssqltips.com/tip.asp?tip=1081]READ_COMMITTED_SNAPSHOT Overview[/url][url=http://www.simple-talk.com/sql/performance/execution-plan-basics/]Simple Talk Execution Plan Article[/url]Cheers,Mike.Fri, 21 Aug 2009 03:28:13 GMTmike.mcquillanhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxGood article, thanks for sharing. all we need now is the other exams covered :-DFri, 21 Aug 2009 01:51:23 GMTSilverfoxhttp://www.sqlservercentral.com/Forums/Topic774806-1627-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/SQL+Server+2008/67599/">Guide to MCITP: SQL Server 2008 Developer</A>[/B]Fri, 21 Aug 2009 00:28:24 GMTmike.mcquillan