Pass Your Microsoft 70-462 Exam Easy!

Passed today smothely with this one, still valid but some new. Thank you peterpan!

Dumps still valid. 29th July. Thanks peterpan.

Hi guys im so nervous and curious on what are they going to suprise me with in administering please help which sections should i focus more on and how many drag n drop questions are there please guys yourhelp will be highly appreciated

still valid, passed with 900 from south africa

Still valid dump. Passed with 866 marks today

Thank you Peterpan! The dump is valid ! 5 new questions are added. I passed today with 916-Canada

thx peter, it was helpfull. got 930+, some answers imo invalid ( sry i will not say witch u have to figure it out).ppl use this BD for finally test before exam not for lemmings-way learn.

Just curious, is the actual test only questions or is there virtual lab portion too?

It's funny that you're all cheating to get these certifications. You're taking time and money to get something that because you cheated you're making into more and more of a farce. No one is going to respect the certs that you cheated to get because you and tons of other people are cheating to get them. way to go.

Hi! I've passed as well, diferent order in some anwers and two or three new questions. Anyway very usefull peterpan, Thanks!

Passed on may 23 with 900, only 2 or 3 questions with differents answers were reworded. THANKS!

Hi!

I passed this exam (50 questions) yesterday 24.5.2013 with 900 score. The exam still valid. Except two questions more or less, the rest of the exam is almost exactly than peterpan's exam. To sum up, this exam is the best practice for administering sql server 2012 certification!

Thank you very much!

Still Valid. Passed yesterday with 9XX. NO new question, only answer of two question were reworded. Thanks a bunch.

passed on thursday 16.5.2013, exam still valid, I think, 3 or 4 questions were different

Passed with 9xx on may 11, valid dump

I passed the exam on 9th of May with 8xx score, a couple of new questions, and other questions have been reworded.Be careful of that.
Now I'll try the 463, probably next week.
Good Luck to Big eyes!

Valid in India - Passed on 7th May 2013 with 883. Only 1 new question.

Hi everyone: passed with this exam still. As people have said some of the questions have been reworded. I received the same new question Wilford from Canada was describing.

Also, the other I remember is question 25 in this exam, the answer is NOT "Domain User". That option isn't one of the answers presented for that question. In its place it had something like "user mapped to a virtual account".

Otherwise, most of the other questions matched up for me. Some minor differences like using "adventureworks" db instead of Contoso and "Server A" as opposed to "Server 1".

Passed with 833.GOod to go for

I Uploaded a new exam file. Not much has changed in the exam but there is some questions that was corrected to the right answer.

its still valid folks I got 960

Passed with 900 score. The dump is valid.

Passed with 833! Valid dump! Thank you Peterpan!

Passed today in sweden with 916 score alot thanks to this so thanks peterpan!

Just passed exam today with 866 score.90% valid

wrong answer of some question not all.need concentrate and understand question

Good luck

just passed the exam with 7xx. still valid in naija. 3 new questions.just need to study em very well.

I will write the Exam on 2013-05-03. I 3 Questions i m not sure.1.) F38 - Generating alerts: SQl Profiler or System Monitor? 2.) F77 -'UserA can still access all the tables, including the Regions table' : I think the right answer is 'REVOKE SELECT ON Object::SchemaCustomers From UserA 3.) F24 'you need to grant ContosoUser can delete rows that are not activ from Supplierts: Can someone verified the answer? I think B or D is correct.

Wrote on 2013-04-30 dump stil valid js 1-2 questions jus mke sure u knw ur prep

Hi guys I am from South Africa and I wrote the exam today and I failed the exam. The exam questions is the same but Microsoft has changed the wording on the exam a lot and they also added 6 new question to the exam. If any body can help in getting a new prep file.

Hi guys I am from South Africa and I wrote the exam today and I failed the exam. The exam questions is the same but Microsoft has changed the wording on the exam a lot and they also added 6 new question to the exam. If any body can help in getting prep file.

Passed today with 8xx. Valid dump. 1-2 questions on exam not in dump.

Still valid. Passed with 8xx. One-Two new questions.
The most part of answers was mixed (in comparison with their positions in DUMP).

Passed with 916.

Passed today with 883, two new questions and one change de anwser. Valid

Passed today with 933, two new questions and one change de anwser but still valid thanks ;)

Top notch! Passed with 9xx. Only one question had slightly different answers which got me confused.

passed on monday 15.4.2013, exam still valid, I think, 3 or 4 questions were different

Passed with 916 on 16th of April 2013. (Poland) Thank you :)

Passed today with 916!

Passed with this dump in France. You have to understand the answer.
Be sure to kown backup
estore scenarios and appropriate troubleshooting tools.

Fantastic dumps,the alternatives were reordered and you need to just validate or verify some of the alteratives you are not too comfortable with. passed the exam with 9XX. all da best.

Think I'm going to have to answer myself here after reading those pages - apparently they do want you to take a backup with "norecovery" of the primary db server to leave it in an unaccessable state ..

Question regarding Q88:
- what does norecovery have to do with a cluster failover? I don't get the answer at all, norecovery is when restore backups, not taking backups? And I don't want to restore as norecovery if I'm failing over a cluster? Or am I missing something?

Excellent dump, Passed today with 900, 2 new questions.

Excellent dump guys. Passed today with over 900. If you study this dump with the few changes discussed in the posts you WILL pass guaranteed. Only a couple of questions were different. Good luck.

lukasis - have all the questions be rewarded?
Thank you,
John

Passed with 866 on 4th of April 2013. (Poland) Questions were very helpful, thank you :)

Sachin, were many of the questions you saw in this dump? Were the answers correct that we see here for most of the questions even though they were reworded?

Thanks..hoping to pass tomorrow as well.

Some how managed to pass with 7xx. 50 questions in exam. Be careful almost all questions & answers were reworded. Seems like exam questions changed from 1st April in India..

Writing this exam Monday April 8th so hopefully this dump is still valid. Thanks for your efforts Peterpan.

Trace flag 1222 is for deadlocks not tracking queries that takeover 1 second, use profiler

Here's a good article on the different management tools sp_who, sys.dm_exec_requests, etc

http://www.mssqltips.com/sqlservertip/2429/how-to-identify-blocking-in-sql-server-2005-and-2008/

Just passed 8xx, thanks PeterPan :)

Still valid in Bulgaria. Pass today 833. No new questions.

valid and passed with score 916

Export data to file using SQL Server Import and Export Wizard.

With a requirement "The first row of the file contains the first row of data" wouldn't you want "column names in the first data row" to remain unchecked?

Kendra Little of BrentOzar.com has a great blog describing the Dedicated Admin Connection (sp_configure 'remote admin connections') if that helps anybody.

http://www.brentozar.com/archive/2011/08/dedicated-admin-connection-why-want-when-need-how-tell-whos-using/

Trace flag 1222 turns on deadlock reporting to the error logs. I have used this for deadlock troubleshooting but have never seen where you can configure it to display OLTP statements taking longer than 1 second to execute.

http://msdn.microsoft.com/en-us/library/ms188396.aspx

Drag and drop question about "users of the application report performance issues." I believe "Generating Alerts" is System Monitor, not Profiler. http://msdn.microsoft.com/en-us/library/ms190700.aspx

Hello, anyone have a link to the CBT Nuggets for this exam. Would appreciate the help.

Stills valid passed to day with 933.
Only two new questions.

Passed with 8xx. few new questions, or reworded. Still passable w. no problem. Thanks Peterpan!

Passed with 866 in Netherlands. at least 25% new questions. Most new questions related to upgrading from sql 2005 and mirroring failover solutions. Also existing questions had some of the answers replaced. Lots of drag and drop questions

Passed with 8xx in Australia. No new questions. Thank you peterpan.

passed today, 2 new Questions, other one changed from reg back/restore from 2005/2012, to VSS Backup/restore on 2012.

thanks. I've passed

Pass today with 900.. Thank you..

it's work. pass with score 916

Thanks peterpan, passed today with 916, in my exam the question 16, doesn't have the restore the full database backup on SQL2012 option.

Thanks Peterpan!

A valid dump, attended this exam on 4 March 2013 and scored good.
Just to mention, total 50 questions, with out new questions.

Valid, passed today with high 800

Thanks Peterpan :)

A valid dump, attended this exam on 27 Feb 2013 and scored good.
Just to mention --
Total 50 questions.
Approximately 6 Question were new.
Options were shuffled for some question with respect to this dump.

My Best wishes for attendees.

Valid. Passed with 916 scores.

I think that it only needed permission on stored proc and one of the tables as due to ownership chaining the person who created the proc was also the owner of one of the tables

Valid! Passed with 833 in USA. Some info on - Q23 (Question 23) . This has UserA who "owns" the Customers table and UserB who "owns" the Orders Table. The question revolves around the Stored Proc GetCustomerOrderInfo. You create a third user (UserC) and it asks which permissions you have to give in order for UserC to execute the Stored Proc. In this dump, the question is limited to only two answers. The actual exam allows you to pick as many as you want. I chose "Execute Permissions on GetCustomerOderInfo", Select on Customers and Select on Orders. I think that is correct. Thank you PeterPan you are awesome!

Valid in england..passed at 800 couple of new questions still passable

Hi, i wonder if the answer for question 55 is correct. The answer leaves the database in bulk logged model. I think the answer must be

Configure the DB in bulk logged mode
execute the bcp tool
Configure the DB in full mode

There is 3 sql servers A B C. Sql 2005
A is primary
B is mirror
C is witness
You need to upgrade A and B to 2012.

Choose 6 steps :

Right order is
1. Remove C from network
2. Upgrade B
3. Failover A to B
4. Upgrade A
3. Failover B to A
6. Add c to network

According to http://msdn.microsoft.com/en-us/library/bb677181.aspx

Dump is valid in Toronto, passed yesterday (Feb 14, 2013). All questions except for the one mentioned in the previous post.

Hi the dump is vaid . Passed with 900.
-I put NOT LIKE in the policies to enable create procedure start with sp-
( i tried it at home , and should be NOT LIKE)
There 8 news questions at all.
Here is a new question that i remember :
There is 3 sql servers A B C.  Sql 2005
A is primary
B is mirror
C is witness
You need to upgrade A and B  to 2012.

Choose 6 steps :

Failover A to B
Failover B to A
Upgrade A
Upgrade B 
Remove C from network
Add c to network
Enable transaction logging in A
Disable transaction logging in B

Dupm si valid, i passed today,all 50 question from the dumps

Passed today with 800. 5-6 new questions.

Dump is valid. Passed today with score 800. Thank you

Dump is Valid. passed yesterday above 80%.

New question with logging to different databases in te same domain. and anserws did not have domain user.
I remeber anserw: user with certificate, or with SID or without login or with password. Was betting on certificate.

Valid dump, thank you peterpan.
Just passed today with score 9xx/1000. Few new question appeared, so if time will allow me I'll post them here.
I also agree with Aleks, I didn't checked that checkbox and that section is 100% correct on my exam result. Therefore Q22 has wrong answer.

I agree with you Aleks. Are the other people agree too? please colaboration.. thank you!

Q22 has wrong answer included.

Question is "The first row of the file contains the first row of data" which means that "Column names in the first data row" should remain unchecked.".

Did The exam on 22nd of January passed with 8something .very good questions and valid dump thank you peterpan.50 questions in the exam.

Passed with 8xx. good prep questions, 50 questions in exam. 11 D & D. Be careful some questions & answers were reworded. Good enough to passed. Thanks alot Paterpan and the PDF questions.

thk you peter,i m studyin hard,but as you know questions are very specific .. so thank you :)

I've had a look about and rounded up the questions from previous posted vce files, It has the same questions as the pdf.. just some of the answers differ