Exam 70-228 SQL Server 200 Administration

[RadioX]

Has anyone taken this exam and if so what should I be prepared to expect. I have the transcender Exams and the Microsoft Training book. I also work with SQL Server 2000 on a daily basis but dont know it as well as I should.

Thanks for your advice
Ron

 

[jjonesal]

In my opinion, the Self Test Software (STS) practice tests mirror the live exam closer than Transcender.

J. Jones
jjones@cybrtyme.com

 

[CassieSimons]

I'm surprised to hear that the STS tests are closer than Transcender to the real exam, although not having used STS for this particular test, I can't comment.

My main tools in preparing for this exam were Transcender (beta version) and Books On Line (very heavily).

I found Transcender very useful for the explanations as to why answers were right or wrong.

Cassie

http://www.ExamsAreEasy.com

????????????????????????
You don't need questions
You need answers.
????????????????????????

 

[MisterJeff]

I just took 70-228 and failed it. This is the 5th MS exam I've taken, and the first one I failed. I don't have experience with SQL Server, so I spent more time studying for this test than for any other -- about 6 weeks. I used Self Test Software and the 700-page book by Osborne/Syngress.

Self Test Software is normally good stuff, but it didn't prepare me for this, and forget about the Osborne book. The largest chapter was about replication, and there wasn't a single question about replication on the test.

Meanwhile, there was a bunch of questions where they give you a page of reading, plus a big exhibit showing the database schema, plus another big exhibit showing all the indexes, and then you have to analyze it and figure out how to improve the query time. Neither STS nor the Osborne book prepared me for these sorts of questions.