Home Page > Microsoft > MB7-841

Download Microsoft.ExamGoal.MB7-841.v2012-08-11.by.Hawaiian.136q.vce

Exam: NAV 2009 C/SIDE Solution Development
Size: 151.06 KB
Posted: 2012-08-11
Votes: 0
Download: Microsoft.ExamGoal.MB7-841.v2012-08-11.by.Hawaiian.136q.vce

Vote For This File

Verification:*
Type the characters from the picture.

Comments

* The most recent comments are at the top.

    • Mam from United States 07 12 2013, 6:27 PM Report Spam
      @TP,congrats on passing the exam. Did you get the questions which Burgos actually got? Or did you get 25/25 from the whole set of questions? Regards
    • TP from United Kingdom 07 12 2013, 6:00 PM Report Spam
      Passed today in UK – 800 – only 2 questions not in here – thanks very much
    • James from Australia 07 09 2013, 3:30 AM Report Spam
      Hi
      Still Valid. A few gothas:
      1.Know CTE's well
      2.Know how to change Log file size via script
      3. Know the Sequence keyword
      4.Understand the questions and answers. Wording is not the same in the real test.
      5.No security or XML questions in my test.
      All the best
    • Nina Z from Brazil 07 08 2013, 2:59 AM Report Spam
      Exam A, Q33 is also wrong. The question clearly mentions APPEND text to a column while the answer B is clearly not appending anything. For that, we should use the .WRITE function with the offset parameter set to NULL.

      I can' t see a right answer in that question. Should the answer A present an ORDER BY clause, I'd choose it as the right one. :-/

    • Nina Z from Brazil 07 08 2013, 12:39 AM Report Spam
      Exam A – Q12: The inline TVF is querying the view presented in the code. But nowhere in the requirements it states that the function should query the view and not the table Orders. I thought the purpose of the proposed function was to replace the view?

      Does anyone confirm that answer is right in the test?

    • Nina Z from Brazil 07 08 2013, 12:18 AM Report Spam
      @greg: you're right about the DENY answer. I just typed that fast. Thanks.
    • Nina Z from Brazil 07 08 2013, 12:16 AM Report Spam
      @greg: I agree with the requirements you mention. That's whay I say it should be UNION ALL. In fact, UNION ALL should be always be considered first since it's the fastest union.

      UNION will have SQL Server spend resources removing duplicates and since there aren't any, it's useless in the situation. Just my two cents.

    • greg from Poland 07 07 2013, 9:05 PM Report Spam
      Nina,

      CQ44 should be "UNION"

      in scenario it is clearly mentioned "None of the rows in Div1cust exist in Div2Cust"

      so UNION ALL is not required while merging results.

      .

    • greg from Poland 07 07 2013, 8:42 PM Report Spam
      hi Nina

      you're right there is mistype in DQ20 na Q19 as well

      but the correct statement should be: DENY <permission> ON <schema> TO <user>

    • Nina Z from Brazil 07 07 2013, 1:59 PM Report Spam
      Exam D – Q20: There is a mistype for the answer H.
      The right command is DENY <permission> TO <user> and not DENY <permission> FROM <user>.
    • Nina Z from Brazil 07 07 2013, 3:31 AM Report Spam
      Exam C – Q44 seems wrong as well:
      The requirement states "Duplicates must be retained" so we should use UNION ALL.
    • Nina Z from Brazil 07 07 2013, 2:44 AM Report Spam
      I forgot to mention: Q36 – Exam C
    • Nina Z from Brazil 07 07 2013, 2:43 AM Report Spam
      Q36 is wrong. First action should be create a condition using NOT LIKE.
    • Pakistani Hero from Pakistan 07 04 2013, 10:56 AM Report Spam
      I Passed the Exam
      I Scored 788/890
      10 New Q's Comes in Real Exam
    • Tron from Unknown 06 28 2013, 7:38 AM Report Spam
      Hi, a short question. When I start the test I can choose between 4 Exams(ABCD). Is it correct that you get in the real test exactly 1 of these 4 exams(with the questions) or do you get a any custom exam with questions from the complete pool?
    • Sasuke from India 06 25 2013, 4:42 PM Report Spam
      Valid in India
      Passed with 900/933
    • Michael from Russian Federation 06 25 2013, 3:39 PM Report Spam
      There were two LIST AND ORDER questions with parts of code by one in each part. I only moved them in correct order. No more, but once code parts were in 5 items nut no in 6 ones like in the dump.
    • Kelly from United States 06 25 2013, 2:12 PM Report Spam
      Michael, did you get any questions on writing tsql query ?
    • Michael from Unknown 06 25 2013, 10:49 AM Report Spam
      There were NO questions of XML and schema/table DENY access FROM role/user.
    • Michael from Unknown 06 25 2013, 10:49 AM Report Spam
      There were NO questions of XMS and schema/table DENY access FROM role/user.
    • Michael from Unknown 06 25 2013, 8:57 AM Report Spam
      Just passed with 833 and 833. Number of questions 25/25 and 1:20 hours for each part.
      I learnt this dump and the lates 70-461 and 70-462.
      Some questions/answers were reworded. A couple of new questions on each part.
    • IDI from United States 06 25 2013, 4:50 AM Report Spam
      Just two
    • Anil from Canada 06 22 2013, 3:39 PM Report Spam
      Thanks IDI, did you get any questions where you have to write the code?
    • IDI from United States 06 20 2013, 11:48 PM Report Spam
      80% From A
    • Anil from Canada 06 19 2013, 7:50 PM Report Spam
      Idi, how many questions did you get from section A in Burgos dump? Please give some hint as i'm planning to take exam very soon.
    • Sam from United States 06 19 2013, 1:56 PM Report Spam
      @ Idi, how many questions did you get from Section A from Burgos dump? please let me know, planning to take the exam soon
    • Idi from United States 06 18 2013, 7:54 PM Report Spam
      just need to prepare the A section all from Burgos dump A section
      pass the exam today
    • Sam from United States 06 13 2013, 2:25 PM Report Spam
      @kingpin, sorry to hear about that. Did you get all the questions from Burgos dump?
    • Kingpin from Bulgaria 06 11 2013, 5:09 PM Report Spam
      Hi all,

      I m stuck with this piece of s…t… Failed it twice… The problem lies in the first part with all this programming. Every fucking option looks exactly like the previous or next one… Esp the first 25 questions (70-461). I passed the second the 70-642 with 8xx but still they give the lowest grade so i fail….
      Any pointers?

    • miki from Bosnia and Herzegovina 06 06 2013, 3:25 PM Report Spam
      Passed it few days ago – still valid, i've had maybe 2-3 questions that were not in this file…
    • Silas from South Africa 06 05 2013, 6:36 PM Report Spam
      Hi guys, I`eve writing a lot of compTIA exam and pass it but now I wanna get to understand SQL DBA. Please send me the code for two exam on 2012 one.
      Thanks
    • David from United States 06 04 2013, 5:21 PM Report Spam
      @TheMan and DBA – I guys, did you get any question where you have to type the code? Or are the questions all multiple choice? Regards David
    • TheMan from United Kingdom 06 01 2013, 8:10 AM Report Spam
      Valid in UK – passed using this – so thanks very much
    • Frank from Unknown 05 23 2013, 2:24 AM Report Spam
      @ Burgos. Please let me know the number of questions you got in Section A and B in the exam. Thank You.
    • DBA from United Arab Emirates 05 18 2013, 6:44 PM Report Spam
      around 85% from this one. passed today 833 in the query part & 866 in administration part. there are new questions
    • Ed from Philippines 05 17 2013, 10:13 AM Report Spam
      valid! 85% came from this. study well!
    • Freeeze from United States 05 17 2013, 8:41 AM Report Spam
      About 80% from this, some with slightly different order or text.
      Not bad for learning.
    • Andre from Unknown 05 16 2013, 3:05 PM Report Spam
      Valid in Brazil. I agree with sirck, 85% of the exam came from this vce. Try to understand the answers and the concepts, not just memorize it .
    • sirck from United States 05 14 2013, 9:16 PM Report Spam
      Valid in the US, thanks Burgos and Derek for your efforts.

      However MS has added new questions, so only about 85% of the exam came from it.

      Some were new questions and some were existing questions with slightly modified answers. So make sure you don't just simply remember the answers and you should know the material as well!

      Good thing is that there was absolutely no free text, code typing of any sort for my one.

    • Mahfoud EL HOUDAIGUI from Morocco 05 14 2013, 9:25 AM Report Spam
      Valid in Morocco, i passed the exam yesterday with 800 in Query and 833 in Administration.
    • Mahfoud EL HOUDAIGUI from Morocco 05 08 2013, 10:29 AM Report Spam
      Jason – Very very good thank's at all, i come to see this option, i just prepare the A section.
    • Jason from United Kingdom 05 07 2013, 5:52 PM Report Spam
      Mahfoud – Did you study all exams in the pack A – D ?
    • Mahfoud EL HOUDAIGUI from Morocco 05 07 2013, 3:10 PM Report Spam
      Not valid in Morocoo 07/05/2012
      The 90% of administration section and 50% of Development section doesn't exist in this dump
    • DBA-Alexa from Colombia 04 26 2013, 3:04 PM Report Spam
      Valid in Colombia – Tks Burgos and Derek
    • user from Russian Federation 04 21 2013, 5:21 PM Report Spam
      Valid in Russia.
      Exam A, Q38.
      Suggested answer is B, but I answered "…to perform transactional replication" (answer F) and scored 1,000 points in admin section.
    • Tony from Netherlands 04 08 2013, 12:03 PM Report Spam
      another tip dont come on here after taking the exam and tell us your score/day you took the exam (Im looking at you J_D_DBA from Colombia). it would be easy to cross reference your scores,date and location to find out who you are and cancel your pass. Just saying be careful.
    • Tony from Netherlands 04 08 2013, 12:00 PM Report Spam
      Valid, I passed the exam sometime in 03ch scoring over 90% in both sections but bear in mind simply memorizing the answer in this dump wont get you a pass, you need to understand why the answers are correct as a lot of the questions although similar to whats contained in the dump are not exactly the same. A few other points some of the answers here are wrong for instance update .write the parameter should be NULL not 0. There were no free text questions. Some of the questions are grouped together and contain the wording "this question is part of a series of similar of similar questions each of which is slightly different and might or might not have different answers". eg questions 10,11,12 and 13 describe similar scenarios and ask you what back up type is most appropriate in each scenario or what type of replication/mirroring is suitable. Best tips I can give you, use this as a guide and most importantly understand why the answer is correct and read the questions carefully eg dont mix up < with >, pay attention to which is primary/secondary server etc, good luck
    • J_D_DBA from Colombia 04 04 2013, 3:19 AM Report Spam
      It is valid in Colombia. Pass with 900/1000 on 04il 1. I passed first session (25 questions of Querying 966/1000). I passed second session (25 questions of administration) 900/1000. Thanks to Burgos and Derek.
    • BlackSun from United States 03 28 2013, 10:23 PM Report Spam

Close

Site Search:

Site Search:

Terms of Service

Proudly powered by www.iexamcollection.com