exam 70 229

  • i am preparing to take the sql server 2000 design exam within the next few months. Could anyone tell me where to find the test exams, iam currently using the sybex study guide, but i need more questions to study. Also i would be very gratefull anyone could tell me how long the exam lasts and how many question there are

    Thanks

  • For practice tests you could go with Transcender or Testking, etc. there are a lot of people who sell practice exams for the test.

    The test was something like 54 questions when I took it. It took me about half an hour, but I was overprepared, if anything. Some of the questions aer quite wordy, so it depends a lot on how fast you read and how much you retain of that.

  • thanks for the info chris

  • Just to amplify I used Transcenders and was impressed. Although they should not be relied on as your total study program.

  • I have taken more than 15 Microsoft exams over the years (haven't failed any yet but have come close once or twice!). I definitely find Transcender to be a useful part of my study program. I certainly don't rely on it completely. Like you, I read a study guide first, use the product itself (if possible) and then tackle the practice exams as the final preparation step before the actual exam.

    I'm not clear if you've ever taken one of the SQL Server exams before. They are exercises in concentration and you should plan for it to take at least 90 minutes, likely more. I'm impressed by that person that said it took 30 minutes. I am a relatively experienced user of SQL Server and I can't see myself writing the exam that quickly.

    If you don't know the answer to a question, mark it and come back at the end. Don't ever leave a question unanswered even if you have to guess.

    Good luck.

    - Mike

  • I would absolutely agree with netmikem. In addition, the trick I have used is to rate my answers on a scale of 1 to 4 (highest to lowest level of confidence) and after the first pass go through answers rated as 2, then answers rated as 3 and finally answers rated as four. In that way you can go back and try and improve your weaker answers. That obviously requires you to closely manage your time, eg. do first pass within 1 hr, and then leave 30 minutes for successive reviews.

  • Believe me, it's nothing impressive. I just do well on those 'standardized' type tests (MCSE, MCDBA, GMAT, eetc. tests). I've taken 14 Microsoft tests, several other vendors certification tests, the GMAT, and a coupl of others that I can't remember the name of right now. There are several techniques that you can use that Transcender reinforces, and the GMAT test prep classes/books go over too. 

    For ex. Without knowing too much about the question, you can almost always throw one answer right out. There's another one that is most likely wrong as well. Then you just have to pick out one of the two (or sometimes more) that are left. This is especially true on the 'best answer' questions. This is a very general thing, and not always true, but it works more often than not.

    I also tend to know an answer or not, Sitting in front of the PC and watching the timer click down doesn't really help me come up with the correct answer. More and more on the MS certification tests, you just have to be a good reader and able to choose what Microsoft would think is right, not what you necessarily would.

  • With regards to the final comment, I too have reached the conclusion that the Microsoft answer is not always the most sensible....or the most relevant for real-world scenarios. Which begs the question of what the MS certifications actually teach you....apart from becoming a better quiz taker

  • I think that they are good for establishing a certain floor level knowledge on the part of the test taker at minimum. You know what is possible, but not necessarily how to do it or the best choice of several possibilities.

    I've heard a lot of people's arguements that certification proves nothing, etc. I wonder why people single that out. It's something akin to saying 'they are fresh out of an undergraduate business degree, but they don't know how to run a business.' All it should mean is that a certification (or degree) alone ensures that the holder has the tools to learn how to do the job (and because of the braindump sites, that's not always true).

    When I got my first black belt (in Shotokan Karate) my instructor said "now you are ready to start learning." When I got my instructors certificate in Kenpo, my instructor said "maybe now you'll learn something" (because I was having to teach others). I don't know why people think that having that piece of paper makes you an expert (either the person with the cert or the management thinking that).

  • I wholeheartedly agree with you....but only if we are talking about what a real education / learning experience gives you.

    In the case of MS (and probably other SW vendors) certification, it seems to me that they have spawned a multi-million (or billion?) private industry that is NOT at all interested in the development of an individual's potential, but only in taking their money. Call me a cynic

  • I have a first edition MS Press study book, which you can have for $25, including shipping, unless you live in Australia or Romania or someplace outside of the states.

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • hey ppl your opinion is actually right i guess as the industry cant be benifitted by highly certified dumbos...

  • hey ppl your opinion is actually right i guess as the industry cant be benifitted by highly certified dumbos...

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply