70-445 Questions and answers

  • Hi evreyone

    This is the request to all of you who have passed and studying for the certification exam 70-445. I have a training kit but i want sample important questions with answers which will give better idea and more vigilance while doing preparations!

    if any one has such , can you please provide them to me , I will be highly grateful !

    Thanks

    -Meghna

  • The training kit should give you an idea of the types of questions and perhaps someone will chime in.

    Exact questions and potential answers, should not be posted as that violates the NDA of the exam.

  • Transcender and MeasureUp are both good. Not cheap though.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • I prefer Transcendor myself. Plus Microsoft's website for certification usually has a 10 question "sample" you can look at.

    If you get more cert study books, aside from the training Kit, those also usually have a practice test or a set of questions on a CD/DVD that you can install on your PC and play with, but they're usually more multiple choice then actual Sim / Case Study style.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • i started studying and that training kit seems interesting , it covers most of the core concepts which is only required to clear this exam!

    try that folks!

  • I wouldn't go personally for Transcender - expensive and far away from the point....:angry:

  • Far away from the point??? What do you mean?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • As a side bar, this is why I hate certifications. They mean nothing because you can get the answers to most of the questions one way or the other and some (many, apparently) would rather spend the time memorizing the answers than learning the skill. 😉

    I've had two certified DBA's where if practical knowledge about SQL Server and-T-SQL were gasoline, they wouldn't have enough to run a sugar-ant's mini-bike through a matchbox. Yes, there are some good ones with certifications... but they probably would have been good even without the certification because they practice their trade instead of book-memorization.

    It generally takes me 2 to 4 questions when I'm interviewing someone to figure out if they've ever done anything worthwhile in SQL Server more than being in the same room with a study guide. They're not difficult questions, either. 🙂

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Oh, yes. I've been on the interviewer side of the table myself. It makes me appreciate that I was smart enough to build myself a SOHO and actually work things through when I was studying for my certs.

    Of course, coming from a retail background, I had a lot more to prove than a lot of people who were already in IT. @=)

    I've actually stumped people with simple backup & restore questions of all things. You'd think *that* particular subject matter would be basic to everyone's DBA knowledge.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Brandie Tarvin (10/10/2008)


    I've actually stumped people with simple backup & restore questions of all things. You'd think *that* particular subject matter would be basic to everyone's DBA knowledge.

    Oh, please... Just take a look at all the backup/restore questions we get here

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • True enough. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Jeff Moden, would you be kind enough to put here your those FEW INTERVIEW QUESTIONS?

    Just wanted to check my own capability.

    Thanks,

    Usman

  • Brandie Tarvin (10/10/2008)


    I've actually stumped people with simple backup & restore questions of all things. You'd think *that* particular subject matter would be basic to everyone's DBA knowledge.

    You could probably stump me with them :w00t:. That's because I am a DB Consultant, and not a DBA most of the time: I rarely have to get my hands dirty with the everyday operational tasks.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • Heh... no... if I posted the questions here, they'd be no better than certification exams. Sorry.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jeff may disagree with me on this, but here's my take on interviews.

    Know your stuff, but if you can't answer the question, be honest about it. Tell the interviewer that you don't know. I've told prospective employeers before that "I don't know the syntax, I usually check BOL before I do it" or "I haven't played with that functionality before" or things like that, depending on the question.

    In my book, there's nothing wrong with those kinds of answers. And if the interviewee seems to know the other stuff, but is weak in an area or two, I'm willing to let them learn on the job, so long as they're not trying to BS their way through the interview.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 1 through 15 (of 22 total)

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