Saswati Mitra from India -
Feb 21 2012, 6:08 PMReport Spam
Can any of you please update that the new questions are from which topics?
Leo from Australia -
Feb 20 2012, 11:31 PMReport Spam
I just have passed in AU 960. the dump is valid. Although, there were 85 questions in total, but i guess 20-25 were new and possibly were not counted towards the result, because there were bloody difficult and different: drug and drop questions, questions with 10 different answers and so on.
China
pass with 980
there are some new questions,about twenty
some about group by and some about windows function
Bill from Netherlands -
Feb 15 2012, 9:10 PMReport Spam
Today I took the exam and passed it. scored 920.
I had total of 85 questions. Lots of questions were from the dump ... but also new ones. Some questions were sort simulation of Query analyzer where, you need to choose proper SQL statements in proper order.
Good luck and thanks for the dump !
lisa from South Africa -
Feb 15 2012, 12:12 PMReport Spam
how long does it take for a dump to expire, plzzzz i realy need to knw
Rohit from India -
Feb 15 2012, 4:36 AMReport Spam
Got 900 . Good Dumps
Lizzy from United Kingdom -
Feb 12 2012, 6:26 PMReport Spam
Valid in Italy, just one question different as commented by Harry (correct answer WITH ENCRYPTION).
Passed
amra from Belgium -
Feb 07 2012, 3:48 PMReport Spam
Still good in Belgium. Passed with 900.
Only 2 new questions on the 55 questions.
Thanks
saswati mitra from India -
Feb 03 2012, 2:39 PMReport Spam
il3mendo
Can you please update that 25% means nearly how many new questions?It will be helpful if you tell what are the new questions?
Lizzy from United Kingdom -
Feb 01 2012, 11:42 AMReport Spam
Hi. Does anybody know that 25% of NEW questions? Has this dump been updated??
il3mendo from Italy -
Jan 31 2012, 10:26 AMReport Spam
Valid in Italy, passed this morning 880. 25% questions were although out of it
saswati mitra from India -
Jan 29 2012, 5:00 PMReport Spam
I will be writing the exam on 13th february.Can any of you please update the dumps if you give the exams in the month of february.Is this dump still valid?Please reply.
SB from Sri Lanka -
Jan 27 2012, 6:09 AMReport Spam
Passed today with 980. There were about 3 new questions. Thanks for sharing. :)
annoymous from United States -
Jan 26 2012, 10:41 PMReport Spam
Valid in States. Scored 980. Few questions had been modified slightly. So just read the questions carefully.
I passed exam today with 90%. still valid in India.
Perera from Sri Lanka -
Jan 23 2012, 9:08 AMReport Spam
I scored 960/1000. 55 questions were there. from Sri Lanka..! Thanks for sharing this.
Anonymous from Netherlands -
Jan 21 2012, 12:53 PMReport Spam
Indeed is Encryption correct, With recompile you speedup a sproc. The other option i only about if you can execute it or not. Although encryption is the answer here. It is easy hackable just google it.
So again another question wich has no realworld value.
aa from Anonymous Proxy -
Jan 20 2012, 2:58 PMReport Spam
Halo the correct answer is
-create procedure ... WITH ENCRYTION
Harry from Germany -
Jan 20 2012, 12:13 PMReport Spam
This dump is valid in Germany. Passed today with a score of 980. There was only one question I hadn´t seen beforehand. It runs like this:
You have created a stored procedure which contains proprietary formulas. You are supposed to ensure that users cannot access the definition of the procedure. What should you do?
-create procedure ... WITH RECOMPILE
-create procedure ... WITH ENCRYTION
-create procedure ... WITH EXECUTE AS OWNER
-create procedure ... WITH EXECUTE AS SELF
I ticked the with encryption option and I think it was right, though I´m not 100% sure.
Thanks buddy!
NICK from Taiwan -
Jan 18 2012, 9:06 AMReport Spam
ı pass it today 880 ......thanks...... form (Taiwan)
kalyani from United States -
Jan 17 2012, 1:37 PMReport Spam
this is valid in us. i got 980/1000.. thanks
X-Men from Unknown -
Jan 16 2012, 1:36 PMReport Spam
Hi Guys,
this Dump is still valid. Last Thursday is passed the Test.
Shank from Croatia -
Jan 13 2012, 4:24 PMReport Spam
ı pass it today 980/1000. Had a couple of new question
Druss from Poland -
Jan 12 2012, 8:41 AMReport Spam
I had just about 3 new questions. Real exam has answers in different order (propably randomly) and sometimes little more text in questions and answers. Generaly this dump is ok and very helpfull :)
PS. My advise - learn what is EXCEPT and INTERSECT
Kedlaw from Poland -
Jan 10 2012, 6:49 PMReport Spam
Tommorow it's my turn. I'll test this dump for you ;)
Martin from Netherlands -
Jan 10 2012, 6:42 PMReport Spam
Goede dump! zonder had ik het niet gehaald...
aanrader voor al mijn collega's
attım hafızaya beyin bedava from Turkey -
Jan 06 2012, 4:07 PMReport Spam
ı pass it today 9001000 is totaly valid
Navin from India -
Jan 04 2012, 1:11 PMReport Spam
This dump is valid. Wrote the exam today , most of the questions from the dump it self.Scored 9xx ;)
Bella from Canada -
Jan 02 2012, 2:26 PMReport Spam
how was your test Omaha?
Omaha from United States -
Dec 27 2011, 9:23 PMReport Spam
I will be taking on 12/20/2011. will let you know
WJ from Dominican Republic -
Dec 27 2011, 6:11 PMReport Spam
valid in DR.. passed with 1000.
josh from Philippines -
Dec 22 2011, 6:44 AMReport Spam
pass with 980
there are some new questions,about twenty
some about group by and some about windows function
I had total of 85 questions. Lots of questions were from the dump ... but also new ones. Some questions were sort simulation of Query analyzer where, you need to choose proper SQL statements in proper order.
Good luck and thanks for the dump !
Passed
Only 2 new questions on the 55 questions.
Thanks
Can you please update that 25% means nearly how many new questions?It will be helpful if you tell what are the new questions?
3 new questions, those are already mentioned in the comments.
Thanks
Q) you are updating a DB table... you need to partition the table to store only the last 1000 rows...
1. add a secondary file...
2. create partition function , create scheme, create distributed view
two options more (not remembered)
not sure on this though which to choose....
So again another question wich has no realworld value.
-create procedure ... WITH ENCRYTION
You have created a stored procedure which contains proprietary formulas. You are supposed to ensure that users cannot access the definition of the procedure. What should you do?
-create procedure ... WITH RECOMPILE
-create procedure ... WITH ENCRYTION
-create procedure ... WITH EXECUTE AS OWNER
-create procedure ... WITH EXECUTE AS SELF
I ticked the with encryption option and I think it was right, though I´m not 100% sure.
Thanks buddy!
this Dump is still valid. Last Thursday is passed the Test.
PS. My advise - learn what is EXCEPT and INTERSECT
aanrader voor al mijn collega's