Sally from Canada – 09 02 2013, 9:47 PM Report Spam Thanks Gabriella, dump valid. If everyone followed your instructions, they will pass for sure. Just passed the exam. Got same questions as Burgos got plus 2 questions from 70 461 dump and 2 from 70 462 dump. The questions in these 2 dumps you won't see it in 70 457 dump. So make sure you prepare by working on all the 3 dumps. Good luck to all. Asim from Pakistan – 08 20 2013, 11:04 AM Report Spam Passed with 933/966. Dumps are still valid in Pakistan.Thanks a lot for Burgos / spuntik. Tron from Unknown – 07 23 2013, 6:45 AM Report Spam Did you have any questions where you have to type in the answer/query manually? Gabriela from Canada – 07 18 2013, 9:17 PM Report Spam I studied 40-757 (sputnik), 70-461 (LionKing) and 70-462 (PeterPan). Plus Microsoft Press books Training Kits for EXAM 70-461, 70-462. Only the questions are not enough but thay help a lot. Anjali from Canada – 07 18 2013, 8:36 AM Report Spam Hi Gabriela, did you study 70 461 dump from lionking for 70 457 exam? I understand that 70 457 is a mixed of 70 461 and 70 462. Is 70 457 dump enough to pass the exam? Regards Anjali Gabriela from Canada – 07 17 2013, 7:49 PM Report Spam I couldn't say if they were the same as Burgos got but they were 95% from this set, reviewed by Sputnik. Please also see my comment on exam 70-461, dumps by LionKing. Sally from United States – 07 17 2013, 6:06 PM Report Spam @ Gabriella, did you get the same questions Burgos got on the exam? Please advise. I'm planning to take the exam in 2 weeks. Any help is highly appreciated. Thanks. Gabriela from Canada – 07 17 2013, 5:19 PM Report Spam Passed today 1000/933. A couple questions that were not in this set, but not very complicated. Another variation on the question with students ranking. Thanks everybody who posted these questions. However I cannot help but wonder if anybody authorized checks these questions… For example, having in a correct answer something like SET STATISTICS SHOWPLAN_XML ON when correct syntax is obviously SET SHOWPLAN_XML ON or other small typos in the drag & drop code is not acceptable… I would have said that word STATISTICS above was the trick to not select that option, but given my perfect score for the 70-461 and that I picked that particular answer because – error excepted – it was the only one making sense, I guess this is it… Anyway, done with this one, proceed with the next. damyll from Belgium – 07 17 2013, 1:29 PM Report Spam You can ignore my previous post, the answer in the exam is correct damyll from Belgium – 07 17 2013, 8:51 AM Report Spam Exam B – Q22 (it think the answer provided by Burgos is wrong) Don't we need DENSE_RANK instead of RANK to make sure that students with the same average are given the same rank. I would go with option C: SELECT StudentCode as Code, DENSE_RANK() OVER (ORDER BY AVG (03ks) DESC) AS ValueFROM Student03ksGROUP BY StudentCode Sputnik from Luxembourg – 07 15 2013, 9:53 AM Report Spam Passed with 900/966. Query and manage XML data is part of the exam. Xyz from India – 07 13 2013, 3:08 AM Report Spam Still Valid;Thanks to Burgos and sputnik!! SIMLA from Denmark – 07 12 2013, 6:18 PM Report Spam On Microsofts page about this exam it seems that "Query and manage XML data" is not a part of the test (in contrast to 70-461). http://www.microsoft.com/learning/en-us/exam-70-457.aspx The first few questions in exam A in this dump seems to related to this topic. Can anyone confirm if "Query and manage XML data" is indeed a part of the exam or not? If not why are the questions part of this dump? Kind regards TP from United Kingdom – 07 12 2013, 5:56 PM Report Spam Passed today in UK – 800 – only 1 or 2 questions not on here, thanks Samy from Switzerland – 07 11 2013, 9:29 AM Report Spam Passed today with 800 on part A and 933 on part B. Only few questions out of this dump. Thank's a lot for your awesome work !!! yash from India – 07 09 2013, 5:40 PM Report Spam Exam A Q17.Why can't the answer be C.For answer "A", it will also bring all the customer records who have not placed any order. SELECT C.LastName, O.OrderDate AS MostRecentOrderDate FROM Customers AS C INNER JOIN Orders AS OON C.CustomerID = O.CustomerIDORDER BY O.OrderDate DESC yash from India – 07 09 2013, 5:18 PM Report Spam The Exam A Q33 seems to be wrong: Correct Answer is C As per MS BOL the new .WRITE clause of the UPDATE DML statement enables partial or full updates and high performance appends to varchar(max), nvarchar(max) and varbinary(max) data type columns. The UPDATE statement is logged; however, partial updates to large value data types using the .WRITE clause are minimally logged. Syntax: .WRITE ( expression, @Offset , @Length ) Tron from Unknown – 07 09 2013, 1:17 PM Report Spam Hi Sputnik, There are a lot of answers at some questions. A-H for example. Is this the same in the exam or are these answers a sum of all answers which have ever seen. Sputnik from Germany – 07 01 2013, 2:53 PM Report Spam Hi Tron,I changed the a lot of the mistakes that were discussed in the thread you can find at the exam file of Burgos. Sputnik from Germany – 07 01 2013, 2:44 PM Report Spam Hi Steven,you will get a mix of 50 questions. 25 about development and 25 about administration. The Exam A – D has nothing to do with the real exams. Steven from Unknown – 07 01 2013, 8:44 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?