Mam from United States - Jul 12, 2013Report 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 - Jul 12, 2013Report Spam Passed today in UK - 800 - only 2 questions not in here - thanks very much
James from Australia - Jul 09, 2013Report 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 - Jul 08, 2013Report 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 - Jul 08, 2013Report 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 - Jul 08, 2013Report Spam @greg: you're right about the DENY answer. I just typed that fast. Thanks.
Nina Z from Brazil - Jul 08, 2013Report 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.
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 - Jul 07, 2013Report 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 - Jul 07, 2013Report 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 - Jul 07, 2013Report Spam I forgot to mention: Q36 - Exam C
Nina Z from Brazil - Jul 07, 2013Report Spam Q36 is wrong. First action should be create a condition using NOT LIKE.
Pakistani Hero from Pakistan - Jul 04, 2013Report Spam I Passed the Exam
I Scored 788/890
10 New Q's Comes in Real Exam
Tron from Germany - Jun 28, 2013Report 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 - Jun 25, 2013Report Spam Valid in India
Passed with 900/933
Michael from Russian Federation - Jun 25, 2013Report 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 - Jun 25, 2013Report Spam Michael, did you get any questions on writing tsql query ?
Michael from Russian Federation - Jun 25, 2013Report Spam There were NO questions of XML and schema/table DENY access FROM role/user.
Michael from Russian Federation - Jun 25, 2013Report Spam There were NO questions of XMS and schema/table DENY access FROM role/user.
Michael from Russian Federation - Jun 25, 2013Report 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 - Jun 25, 2013Report Spam Just two
Anil from Canada - Jun 22, 2013Report Spam Thanks IDI, did you get any questions where you have to write the code?
IDI from United States - Jun 20, 2013Report Spam 80% From A
Anil from Canada - Jun 19, 2013Report 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 - Jun 19, 2013Report 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 - Jun 18, 2013Report Spam just need to prepare the A section all from Burgos dump A section
pass the exam today
Sam from United States - Jun 13, 2013Report Spam @kingpin, sorry to hear about that. Did you get all the questions from Burgos dump?
Kingpin from Bulgaria - Jun 11, 2013Report 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.
miki from Bosnia and Herzegovina - Jun 06, 2013Report 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 - Jun 05, 2013Report 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.
David from United States - Jun 04, 2013Report 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 - Jun 01, 2013Report Spam Valid in UK - passed using this - so thanks very much
Frank from Russian Federation - May 23, 2013Report 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 - May 18, 2013Report Spam around 85% from this one. passed today 833 in the query part & 866 in administration part. there are new questions
Ed from Philippines - May 17, 2013Report Spam valid! 85% came from this. study well!
Freeeze from Germany - May 17, 2013Report Spam About 80% from this, some with slightly different order or text.
Not bad for learning.
Andre from Brazil - May 16, 2013Report 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 - May 14, 2013Report 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 - May 14, 2013Report Spam Valid in Morocco, i passed the exam yesterday with 800 in Query and 833 in Administration.
Mahfoud EL HOUDAIGUI from Morocco - May 08, 2013Report 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 - May 07, 2013Report Spam Mahfoud - Did you study all exams in the pack A - D ?
Mahfoud EL HOUDAIGUI from Morocco - May 07, 2013Report 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 - Apr 26, 2013Report Spam Valid in Colombia - Tks Burgos and Derek
user from Russian Federation - Apr 21, 2013Report 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 - Apr 08, 2013Report 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 - Apr 08, 2013Report Spam Valid, I passed the exam sometime in March 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 - Apr 04, 2013Report Spam It is valid in Colombia. Pass with 900/1000 on April 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 - Mar 28, 2013Report Spam not valid in the US. About 20 out of 25 not in the dump file
Tonio from France - Mar 28, 2013Report Spam Valid in France!
I had 2 or 3 questions not in the dump and I think that 1 or 2 answers may be wrong, but still manage to have 87%!
husnuben from Turkey - Mar 25, 2013Report Spam Thanks for your sharing Burgos! I passed the exam!
But I think some of the answers are absolutely wrong!
I passed first session (25 questions of querying) 700/1000. Passing score is 700 as you all know. I almost failed the first session although I memorized all of your answers.
I passed second session (25 questions of administration) 866/1000.
jpop from Brazil - Mar 08, 2013Report Spam valid in brazil. some questions need attention, the scenery is not exactly like vce, can bring it some confusion. similar questions about rank dense rank, read it carefully.
mrC from United Kingdom - Mar 07, 2013Report Spam Valid
Austin from United States - Mar 04, 2013Report Spam Valid!
Unknown from United States - Feb 21, 2013Report Spam Thanks Burgos
Burgos from Brazil - Feb 21, 2013Report Spam Dear Unknown, questions with "YES" I think that appears im my exam (equal or similar). Questions with "NO" did NOT appears in my exam.
Unknown from United States - Feb 20, 2013Report Spam Why do some of these questions say Burgos - No and Burgos - Yes.
Does no mean the answer is wrong?
Burgos from Brazil - Feb 19, 2013Report Spam Lancaster, you are correct. I put any possibilities, , A alwwas is the suggested answer. So, I had NO free text questions.
Pancho from United States - Feb 19, 2013Report Spam Q32: Question about the BlogEntry is correct, the question says : Append specific string to the Summary column" and not append a record to the table if you append a string to the column you are updating the column, I think this is more English interpretation than SQL.
Per from Denmark - Feb 19, 2013Report Spam @Bob - The page restore is not possible on the reporting DB, as it's in Simple mode. Hence the combo of Full/Diff.
Took the exam recently and passed. No typing of queries for me.
Unknown from United States - Feb 18, 2013Report Spam Exam C, Q44.
I think this should be union all in order to retain duplicates. Someone, please confirm.
Bob from Australia - Feb 18, 2013Report Spam Exam C, Q12.
Suggested answer is b:
"create proc blah with execute as user = 'dbo' as delete from blah"
User='dbo' isn't valid & gives a syntax error. If this was the answer, it should be
"create proc blah with execute as 'dbo' as delete from blah"
I think the right answer is D - ownership chaining means that the delete permissions are never checked on the underlying table. http://msdn.microsoft.com/en-us/library/ms188354.aspx
Bob from Australia - Feb 18, 2013Report Spam Exam C, Q2 (item 4 of 45)
Talks about having 3 corrupt pages, and how to restore.
Suggested answer is restore a full backup and a diff - no t-log backups - how is that the right answer?
Surely if you need to restore with minimal data loss, you want to restore the t-logs along with full/diff?
Lancaster from Brazil - Feb 18, 2013Report Spam I'm assuming that the questions with only two options, are questions that you have to type in the queries yourself, am I right?
Peter from Denmark - Feb 12, 2013Report Spam Exam C, Q38 is not correct either. It marks SQL Profiler as the tool for "Generating events". This is not correct. The correct answer is System Monitor:
@Marc - The only other option I saw was the Synchronous server on the same subnet. I'm not 100% sure if that'd be a correct option or not.
Marc from Brazil - Feb 12, 2013Report Spam Thanks Peter to confirm that.
So I'd say Replication is the right answer, as its the only solution that keep DB online.
Burgos from Brazil - Feb 12, 2013Report Spam Jason, did NOT have any "write free text" questions NOR "hot spot" questions NOR "simulation" questions.
I allready had "one choice" questions, "multiple choice" questions, "drag and drop" questions and "ordered list" questions.
Santi from Spain - Feb 11, 2013Report Spam I agree with Peter from Denmark. The question about BlogEntry is wrong. We need to "append" the text, with the query proposal in the answer, we overwrite the whole string. The correct answer to this question is 'C'
Peter from Denmark - Feb 11, 2013Report Spam Marc is correct. Active |Secondaries cannot be indexed:
Marc from Brazil - Feb 05, 2013Report Spam Q38 > I thought an Active secondary replica could only be configured as read-only database. So an Index cannot be created in it. If not, transactional replication could be the answer ?
Jason from United States - Feb 04, 2013Report Spam Hi Burgos. can you tell me if the exam contains sections where you have to write out the sql script of is it all multiple choice? Thanks for the upload, great for studying :) J
Burgos from Brazil - Feb 03, 2013Report Spam Thx Hamilton!
Peter from Denmark - Feb 01, 2013Report Spam The answer on the BlogEntry table is wrong. The answer marked as correct (and verified) does not do as the question asks for (which is appending to the Summary column). Instead, it replaces the Summary column.
Answer C is correct, though.
Peter from Philippines - Jan 30, 2013Report Spam Valid Dump! Passed the exam today but few new questions. Good Luck to All! :)
Peter from Denmark - Jan 29, 2013Report Spam Regarding question 23, the answer will not compute. Instead it will throw an error:
Cannot schema bind view 'Sales.uv_CustomerFullName' because name 'Customers' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.
This would compile, though:
CREATE VIEW Sales.uv_CustomerFullName
SELECT FirstName, LastName
How exactly does the query part of the exam work? Is there an actual parser available, or would you really have to type up code in one go without being able to verify it?
Reinaldo Maciel from Brazil - Jan 28, 2013Report Spam Burgos é o cara! Burgos is the man!!
Burgos from Brazil - Jan 28, 2013Report Spam It is valid im Brazil. Pass with 900/1000 (session with 25 QUERYING questions with 80 minutes) and 933/1000 (session with 25 ADM questions with 80 minutes) today. I uploaded new version of this dump (will be avaiable soon).
Vote For This File
Please Log In to download VCE file
Please provide a correct E-mail address Please provide your Password (min. 6 characters)
Only registered Examcollection.com members can download vce files.
Registration is free and easy - just provide your E-mail address. Click Here to Register