70-450. how deep do i need to go

  • I recently took the 70-450 exam and failed, gaining a score only of 680 and am sudying to take it again in the next few weeks.

    Im going through technet articles (and SQLRNNR's excellent study guide) to study the recommended areas for the 70-450 database admin exam, and im getting a bit overwhelmed. There are 30-40 topics, and depending on the topic, you can go very deep into them.

    e.g. merge replication. do i need to know the intricate details of how it performs conflict resolution, writing my own conflict resolvers etc, or are questions generally at a higher level, e.g " you have to design a system with these requirements, should you chose merge replication, tran repl" ?

    If i go down to the deep level on each topic, i will be studying for 6 months and theres no way i will remember all of that information.

    from folk who have passed this exam or are sql certified masters, how deep does the 70-450 exam go?

  • Not very deep. Know the concepts, where you'll use them, what would make you chose feature X over Y (and what would make one or the other not applicable).

    p.s. I don't know how merge replication handles conflicts and I certainly couldn't write my own conflict resolve. I got 800+ on 450 (can't remember exact score and don't feel like hunting results down)

    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
  • As Gail said, the exam is to test your understanding of what to use and not the intricate details. Also, if you have been doing this kind of work for a while, you may not need to study too terribly much. Your experience with the product will help tremendously.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thanks guys. Info is really appreciated. Gives me a much better idea of what to practice and read up on.

  • i passed 70-450 exam and i did preparation from braindumpscity.com study material .it's good for exam preparation

  • alyssajames37 (1/12/2012)


    i passed 70-450 exam and i did preparation from braindumpscity.com study material .it's good for exam preparation

    So you admit to cheating and violating the NDA?

    Braindumps are not an appropriate study material.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • alyssajames37 (1/12/2012)


    i passed 70-450 exam and i did preparation from braindumpscity.com study material .it's good for exam preparation

    This makes me very angry, some of us dedicate a month to study books and material to pass these exams, and feel proud when we pass because we earned it.

    Should I and alyssajames37 apply for the same position at a company, our certifications are equal, but we are not.

    Hope someone reported this?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • alyssajames37 (1/12/2012)


    i passed 70-450 exam and i did preparation from braindumpscity.com study material .it's good for exam preparation

    Braindumps are cheating. They are actual questions taken from the exams in violation of the NDA that all exam takers must accept. Using or distributing braindumps can result in your certifications being revoked and even in you being blacklisted from ever writing certification exams again.

    http://www.microsoft.com/learning/en/us/certification/exam-policies.aspx#tab2

    The Examinee may be prohibited from taking any Microsoft Certification Exams, and/or may be decertified from Microsoft Certification Program if Examinee violates this Exam Agreement and/or engages in any misconduct. Proctors are authorized to take immediate and appropriate measures against Examinees who violate testing rules. This policy is enforced to ensure the integrity of the Exams and Microsoft Certification Program. Examples of misconduct and/or misuse of the Exam include, but are not limited to, the following:

    * Modifying and/or altering the original results/score report for this Exam or any other exam records

    * Violation of the current exam retake policy

    * Fraudulently impersonating another to gain access to the Exam

    * Submission of any work that is not completely your own

    * Providing or accepting improper assistance

    * Using unauthorized materials in an attempt to satisfy Exam requirements (this includes using brain-dump material and/or unauthorized publication of Exam questions with or without answers)

    * Disseminating actual Exam content

    *Possession of non-authorized items at the testing center during an Exam

    * Misconduct as determined by statistical analysis

    * Copying, publishing, disclosing, transmitting, selling, offering to sell, posting, downloading, distributing in any way, or otherwise transferring, modifying, making derivative works of, reverse engineering, decompiling, disassembling or translating any Exam in whole or in part, in any form or by any means, verbal or written, electronic or mechanical, for any purpose

    I'd report this post to Exam Fraud, but this is likely just a spammer promoting the site with fake email address and fake name.

    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 have some doubts here on this topics.. Can someone please give some lights on this?

    1. Why Microsoft dont take actions on those actual dumps providers when illegal?

    2. These dumps contains around 100-150 questions and same questions gets repeated in the exam. So it gets easier for the people to go through these questions and get good score. So as per my opinion Microsoft should not repeat the questions from the same set which is really small. What do you think?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • Sumanta Roy (1/13/2012)


    I have some doubts here on this topics.. Can someone please give some lights on this?

    1. Why Microsoft dont take actions on those actual dumps providers when illegal?

    They do. Legal action.

    2. These dumps contains around 100-150 questions and same questions gets repeated in the exam. So it gets easier for the people to go through these questions and get good score. So as per my opinion Microsoft should not repeat the questions from the same set which is really small. What do you think?

    They don't, the set is not as small as you may think and there are new questions being added all the time. That said, with hundreds of exams written a month, there's no way that they could not repeat questions, they certainly couldn't all be complete custom exams.

    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 just want to say i started this post asking for some advise on the best study strategy for this exam and did not want or expect brain dumps to come into the conversation. I dont use or condone the use of brain dumps.

    Besides, If a legit study aid like trancender gets questions wrong ( ive identified a number of them that are wrong for this and other exams), then why would anyone expect that these dodgy brain dumps are accurate?

    From looking back on the Certification forum here, there seems to be a few posts like that one promoting brain dumps, by users who just registered and only have 1 or two posts.

    Is there some form of security that could be put in place, like any new users (users with less than 2 posts) have their posts screened for words like brain dump, exams etc, and of the posts identified, an admin could screen them once a day. Im sure there are a lot of new users, but there cant be that many posting in the certification on a daily basis.

Viewing 11 posts - 1 through 10 (of 10 total)

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