Pass Your Microsoft 70-462 Exam Easy!

Get 100% Real Exam Questions, Accurate & Verified Answers By IT Experts

Fast Updates & Instant Download!

Certification Exam: 70-462 (MCSA Administering Microsoft SQL Server 2012/2014 Databases)
70-462 Premium VCE File

Microsoft 70-462 Premium File

319 Questions & Answers

Last Update: Sep 07, 2024

$69.99

70-462 Bundle gives you unlimited access to "70-462" files. However, this does not replace the need for a .vce exam simulator. To download VCE exam simulator click here
70-462 Premium VCE File
Microsoft 70-462 Premium File

319 Questions & Answers

Last Update: Sep 07, 2024

$69.99

Microsoft 70-462 Exam Bundle gives you unlimited access to "70-462" files. However, this does not replace the need for a .vce exam simulator. To download your .vce exam simulator click here

Download Free 70-462 Exam Questions

Exam 70-462 - MCSA Administering Microsoft SQL Server 2012/2014 Databases
Size: 1.33 MB
Posted Date: Wednesday, August 14, 2013
# of downloads: 262
Free Download:
  Download Free 70-462 Exam Questions
Exam
70-462 - MCSA Administering Microsoft SQL Server 2012/2014 Databases
Size
1.33 MB
Posted Date
Wednesday, August 14, 2013
# of downloads
262
Comments
* The most recent comment are at the top
Pages:  1 2  [>]  [>>]
  • Malcolm C. Herman
  • United States
  • Oct 14, 2014

Emergency!!! Who can tell me what is Braindump2go dumps? Their questions are useful for real test?

  • Oct 14, 2014
  • Harvey J. Ford
  • United States
  • Oct 13, 2014

@Nelson G. Keesee
Hello Nelson, I am also from American - I passed my70-462 Exam yesterday with a satisfying grades! I wish that my experience can also help you pass this exam successfully! I used Braindump2go new updated Microsoft 70-642 Practice test questions and spent 1 month to understand all the questions in that dump then I passed easily! I think you can search Braidnum2go free dumps online but remember it must be the latest updated version! Good luck for you! Wait for you good news:)

  • Oct 13, 2014
  • Nelson G. Keesee
  • United States
  • Oct 13, 2014

My friends Jim failed his 70-462 Exam today and he told me this file is no longer useful! But how we can do? We really need to pass this exam urgently!!! Anyone can help? Someone used Braindump2go Microsoft 70-462 free dumps before and finally passed this exam???? Waiting for kind-hearted people

  • Oct 13, 2014
  • Raj
  • United States
  • Sep 24, 2014

Please somebody answer this questions since different collection of different answers.

You administer a Micosoft AQL server 2012 failover cluster.
You need to ensure that a failover occurs when the server diagnostics returns query_processing error.

Which server configuration property should you set?
A. sqlOumperDumpFlags
B. failoverConditionLevel
C. HealthCheckTimeout
D. AqlDumperDumpPath
------------------------------------------------------------------------------------------------------------
You administer a Microsoft SQL server 2012 server
Some applications consume significant resources. You need to manage the server workload by restricting resource-intensive applications
You need to dynamically limit resource consumption

What should you do?
A. A set up service broker to ensure that application are not allowed to consume more than the specified amount of resource
B. Configure resource pool, workload groups, and classifier function, and enable the resource governor
C. Configure extended events to monitor and restrict resource limits allowed by each application
D. Create a new plan guide with a scope of sql and define the resource limits for each application
------------------------------------------------------------------------------------------------------------
You administer a Microsoft SQL server 2012 database.
Users report that a billing application becomes unresponsive during busy times of the day.
While investing, you notice large number of process taking or waiting for the table locks.
You suspect that sql servet is assigning stronger locks to queries.
You start a SQL Profiler trace

Which event should you select?
A. Deadlock Graph
B. Lock:Escalation
C. Lock:Timeout
D. Lock:Deadlock
------------------------------------------------------------------------------------------------------------
You administer a Windows azure SQL Database named Inventory that contains stored procedure named p_AddInventory.
Users need to be able to SELECT from all tables in the database and execute the stored procedure
You need to grant only the necessary permissions.
What should you do?
A. Grant EXECUTE permission on p_AddInventory to all users. Grant VIEW DEFINITION to all users.
B. Grant EXECUTE permission on p_AddInventory to all users. Add all users to the db_datawriter role.
C. Add all users to the db_owner role.
D. Grant EXECUTE permission on p_AddInventory to all users. Add all users to the db_datareader role
------------------------------------------------------------------------------------------------------------
You administer a Microsoft SQL server 2012 instance that has multiple databases. You have a two-node sql server failover cluster. The cluster uses a storage area network(SAN).
You discover I/O issues. The SAN at capacity and additional disks cannot be added.
You need to reduce the I/O workload on the SAN at a minimum cost.

What should you do?
A. Move user databases to local disk
B. Expand the tempdb data and log files
C. Modify application code to use table variables
D. Move the tempdb files to local disk
------------------------------------------------------------------------------------------------------------
You administer a Microsoft SQL server 2012 environment. One of the sql server 2012 instances contains a database named Sales.
You plan to migrate sales to Windows Azure SQL Database.
To do so, you need to implement a contained database.

What should you do?(each correct answer presents part of the solution. Choose all that apply.
A. Set database containment to AZURE
B. Enable server property contained database authentication
C. Disable server property cross db ownership chaining
D. Set database containment to PARTIAL
E. Disable server property contained database authentication
F. Set database containment to full
------------------------------------------------------------------------------------------------------------
You administer a Microsoft SQL server 2012 instance named SQL2012. You are in the process of migrating from a SQL server 2008 to the SQL2012 instance.
You have upgraded a database from the SQL2008 instance by side-by-side migration technique.
You need to migrate the sql server logins from the SQL2008 instance to the SQL2012 instance

What should you do?
A. A back up the master database on the SQL2008 instance. Restore the master database on the SQL2012 instance
B. Use the Transfer logins task in a Microsoft SQL server integration service package.
C. Use sp_graphlogin
D. use xp_logininfo
------------------------------------------------------------------------------------------------------------
You install a Microsoft SQL server 2012 instance.
The instance will store data extracted from two databases running on Windows Azure sql database.
You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of the database.
You need to ensure that the data steward is given the correct client tools to perform this task.
Which set of tools should you install?
A. SQL server managemetnt Studio and Distributed Replay Client
B. Master Data Services and Data Quality Client
C. Data Quality Client and Distributed Reply Client
D. Data Quality Client and SQL Server Management Studio
------------------------------------------------------------------------------------------------------------
You administer a Microsoft SQL server 2012 Enterprise Edition server that uses 64 cores.
You discover performance issues when complex calculations are performed on large amounts of data under heavy system load.
You need o limit the number of cores that handle the processing.

What should you configure?
A. Max worker threads
B. Processor affinity
C. I/O affinity
D. Lightweight pooling

  • Sep 24, 2014
  • rhyne
  • Singapore
  • Aug 11, 2014

hi guys, I took the exam last sat August 09, 2014. This dump is not valid, too many wrong answers. I studied this dump and this "Microsoft.Certkiller.70-462.v2014-06-18.by.LARA.169q.vce" .. I also checked both conflicts answers on this dump..lara and Vivian through other online reviews and forums.. Lara's dumps appeared to be more valid than this.. I passed with high scores. You can do it.. Aja Aja Fighting! :)

  • Aug 11, 2014
  • Shyam
  • India
  • Apr 22, 2014

Any valid dumps available for this exam ?

  • Apr 22, 2014
  • KAIZER
  • Apr 21, 2014

guys found these questions, let me know if they are useful http://www.4shared.com/office/e3I3fyz6ba/70-462.html

  • Apr 21, 2014
  • kaizer
  • Apr 15, 2014

not valid, need dump before May 31

  • Apr 15, 2014
  • Patrick
  • Australia
  • Mar 25, 2014

Does anyone know If premium vce is valid?

  • Mar 25, 2014
  • romeo
  • South Africa
  • Mar 19, 2014

Beast, please Upload the lead@pass dump..ur assitance will be highly appreciated...

  • Mar 19, 2014
  • Adam
  • United States
  • Mar 12, 2014

Dump not Valid! Maybe 60% Valid. New Questions asked of me consisted of a Quorum question that had 5 nodes and which would be the best Quorum Configuration. Since it was an Odd number above 3 this should be Node Majority. Another question ask me importing Azure tables(Guessed / can't remember ), another question was about hard drive partitions and allocating your db's based off type of hard drive and raid levels.

  • Mar 12, 2014
  • sushma
  • India
  • Mar 11, 2014

These dumps are expired now......!no more questions are there in exam .please wait in hope that somebody can upload it .

  • Mar 11, 2014
  • Sniffer
  • Israel
  • Mar 11, 2014

Guys, Microsoft changed the test questions before the 20 days, can anyone Upload VCE questions updated?

  • Mar 11, 2014
  • S.A
  • United Kingdom
  • Mar 01, 2014

i have failed this exam on the 25 feb, truest me this exam its not valid only 5% of queations are from this exam.

who ever willing to help can post the later valid vcs. azuru just kicked my ass. i wish to re-take this exam again soon.


take you for the help in advance.

  • Mar 01, 2014
  • Rök
  • Costa Rica
  • Feb 28, 2014

still valid in america just 10 new question of sql azure and logins.

  • Feb 28, 2014
  • piv47
  • Italy
  • Feb 28, 2014

fail with 678.
new question on Azure, configure, failover and data management
this dump is now 50-60% valid

  • Feb 28, 2014
  • Deez
  • United States
  • Feb 28, 2014

Sorry NewQ I wish I had a photographic memory but I can only recognize if I see questions again. Still searching but no luck :(

  • Feb 28, 2014
  • Alex
  • Lithuania
  • Feb 27, 2014

619 fail, question :Azure, audit(code), sertificates(code) not include

  • Feb 27, 2014
  • Margot
  • Australia
  • Feb 27, 2014

Can someone please post the new questions ASAP?

  • Feb 27, 2014
  • NewQ
  • United States
  • Feb 26, 2014

Deez or SK, can you please post the new Questions that you have seen...

  • Feb 26, 2014
  • Katherine
  • New Zealand
  • Feb 26, 2014

Dump half valid. 50% new quesitons. Failed my exam. 659. Azure, failover questions are not in the dump

  • Feb 26, 2014
  • Deez
  • United States
  • Feb 25, 2014

Did not pass 50% new question Azure and some other odd ones I've never seen before. I did see 3 questions from link indi posted in exam Thanks indi! Someone please post new questions.

  • Feb 25, 2014
  • SK
  • United States
  • Feb 24, 2014

There were at-least 15 new questions. Passed with margin percentage.

  • Feb 24, 2014
  • indi
  • Singapore
  • Feb 22, 2014

Dump is partly valid, 50% of questions new or slightly changed. I got two new questions from this link
http://www.mcsaquestion.com/latest-mcsa-70-462-dumps-real-exam-download-71-80.html

67 and 69

  • Feb 22, 2014
  • telessa
  • Switzerland
  • Feb 22, 2014

Sorry about my bad english.

I have a suggestion.
Since everybody is talking about (AZURE) questions.
I have found a similar questions on other dumps(about
"AZURE" questions), but it must be confirmed from those who Took the exam.
The dumps are:

Microsoft.Braindumps.70-463.v2014-01-23.by.Aussie.216q

Microsoft.Testpapers.70-461.v2013-12-27.by.Jaime.53q

I Need to mention that i have found some exact questions in this and those other dumps.

  • Feb 22, 2014
  • YM
  • Ireland
  • Feb 21, 2014

Passed few days ago. 40% new questions, Azure,failover clusters etc...
Old questions are changed a bit.

  • Feb 21, 2014
  • Andre
  • Portugal
  • Feb 21, 2014

This dump was not valid yesterday, passed with 917 but there was like 5 questions from this dumps, the others all new, specially Azure.

  • Feb 21, 2014
  • rohit singh
  • India
  • Feb 21, 2014

yesterday i failed got only 503/1000 more than 50% question changed!!!

  • Feb 21, 2014
  • Tom
  • Australia
  • Feb 21, 2014

Did the exam last week and passed with 9XX score. There were only 3 - 5 quiz new or slightly changed.

  • Feb 21, 2014
  • Rob
  • Netherlands
  • Feb 20, 2014

Dump is only partly valid. Also had 50 Questions. Around 30% new not in this dump. (AZURE)

  • Feb 20, 2014
  • rohit singh
  • India
  • Feb 20, 2014

Hi I too failed looked like more than 50% question were out of dumps... and some new question on window Azure also!!!!

  • Feb 20, 2014
  • rahul
  • India
  • Feb 20, 2014

It is not valid failed more than half of the questions are not valid........

  • Feb 20, 2014
  • jl
  • Czech Republic
  • Feb 20, 2014

More than half of questions changed or different. Scored 816 points however :)

  • Feb 20, 2014
  • AbKingPro
  • Germany
  • Feb 20, 2014

My exam had 50 questions, of which 15 questions were NOT on this dump. Passed anyways.
Study this dump thoroughly, if you don't understand something, research the answer. The 15 new questions were tough, but using your brain you can also answer some of them! Good luck!

  • Feb 20, 2014
  • Harshit
  • India
  • Feb 19, 2014

Not valid anymore....
FAILED!!!

  • Feb 19, 2014
  • Jez
  • Czech Republic
  • Feb 19, 2014

Passed with 766. 50 questions, approx 30% of them were new, that are not in this dump.

  • Feb 19, 2014
  • Feyruz
  • Turkey
  • Feb 19, 2014

Fail 547 this exam .. Some Questions wrong and 20 or 25 new Questions..

  • Feb 19, 2014
  • Jegan
  • India
  • Feb 19, 2014

Dear All,

Can anyone please let me know whether this dump is valid in India ( Chennai). I am going to take this exam on coming friday. Please help :(

  • Feb 19, 2014
  • mak
  • Canada
  • Feb 18, 2014

Failed....not valid more than half questions are changed.

  • Feb 18, 2014
  • mak
  • Canada
  • Feb 18, 2014

Not valid anymore half new, failed.

  • Feb 18, 2014
  • RusLeon Trotsky
  • Sri Lanka
  • Feb 14, 2014

Still Valid !! Thanx !!

  • Feb 14, 2014
  • Gman
  • South Africa
  • Feb 14, 2014

Still valid, 2 new questions. Thank you Raman!

  • Feb 14, 2014
  • meriem
  • Morocco
  • Feb 09, 2014

dump still valid, however there were 2 new questions and same questions with slightly different answers.

  • Feb 09, 2014
  • Mike
  • United States
  • Feb 07, 2014

Yep, its good. I passed with 910/1000. Also used testking and :

http://mssqlonline.com/?page_id=54

  • Feb 07, 2014
  • Ramesh
  • United States
  • Feb 07, 2014

Still valid. Read questions carefully.

This site helped me:
http://mssqlonline.com/?page_id=54

So did MS:
http://www.microsoft.com/sqlserver

  • Feb 07, 2014
  • andy
  • United States
  • Feb 07, 2014

Yes this is valid. Passed today

  • Feb 07, 2014
  • vishal
  • Singapore
  • Feb 07, 2014

Dump still valid, passed with 8** today, Bangalore, India

  • Feb 07, 2014
  • Telessa
  • Switzerland
  • Feb 06, 2014

Part1, Q8 any suggestion about third part =
F. The Select permission on Orders
?????

  • Feb 06, 2014
  • David
  • Spain
  • Feb 06, 2014

Still very valid, at least in Spain...got my exam this mornig...scored 9XX...a few new questions and one same question with slightly different answers.

Thx for the help!!!

  • Feb 06, 2014
  • Ramesh
  • India
  • Feb 06, 2014

Passed with 883.this dump is still valid...

  • Feb 06, 2014
  • Kris
  • United Kingdom
  • Feb 06, 2014

Yes, the dump is valid, however there were 5 new questions including a simulation on migration of SQL Server Mirroring from SQL 2008 to SQL 2012.

Thanks Raman for your valuable dumps

  • Feb 06, 2014
  • allen
  • Canada
  • Feb 06, 2014

Valid dump in Canada as of Feb05

  • Feb 06, 2014
  • Ramesh
  • India
  • Feb 05, 2014

Still this dump is valid?

  • Feb 05, 2014
  • Phil
  • France
  • Feb 04, 2014

Still valid in France
Thanks Raman !!!!

  • Feb 04, 2014
  • Kumar
  • Canada
  • Feb 04, 2014

This dump is 100% valid.. wrote an exam recently...no new questions outside of this dump.....

  • Feb 04, 2014
  • mikaze
  • Belgium
  • Feb 04, 2014

Few new question but still very valid.
passed with 9xx ^^

  • Feb 04, 2014
  • Pixie
  • Nigeria
  • Feb 03, 2014

This dump is still valid. Passed today with 8xx. One new drag and drop question as well as two new multiple choice questions.

  • Feb 03, 2014
  • Ramesh
  • India
  • Feb 03, 2014

Can anyone pls post some simulator questions?

  • Feb 03, 2014
  • MDN
  • United Kingdom
  • Feb 02, 2014

Passed exam today with 8** dump valied KUDOS Raman you are a champ dude

  • Feb 02, 2014
  • Kumar
  • Canada
  • Feb 01, 2014

Writing this test next week, Can anyone pls tell if this dump is still valid..thnx

  • Feb 01, 2014
  • Indramouli
  • United States
  • Jan 31, 2014

I sthis dump still valid?

Please let me know, Thank you!!

  • Jan 31, 2014
  • Ramesh
  • India
  • Jan 31, 2014

Is there any simulator questions? If there pls mention. Am going to write exam on coming Feb 4th 2014.

  • Jan 31, 2014
  • narkooo
  • Poland
  • Jan 22, 2014

Dump valid. Today passed in Poland with >800. A few new question.

  • Jan 22, 2014
  • Josh
  • Israel
  • Jan 22, 2014

Dump still valid. Passed Sunday with 883. Order changes. Also see how to set log limit via SQL code.

  • Jan 22, 2014
  • shuffle
  • Italy
  • Jan 21, 2014

Exam A, Q4.
Answer is : A,C,D
Someone agrees with me?

  • Jan 21, 2014
  • mohammad
  • Saudi Arabia
  • Jan 20, 2014

Did this dump is still valid ?

  • Jan 20, 2014
  • William
  • Canada
  • Jan 19, 2014

Took the exam today and still valid passed with 800 score.
Thanks for the great effort.

  • Jan 19, 2014
  • Sukesh
  • United States
  • Jan 19, 2014

Passed today with 9xx in LA, California . 75% questions from this dumps. I followed CBT Nuggets 70-462 videos and practiced these dumps.

  • Jan 19, 2014
  • Rigby
  • Germany
  • Jan 18, 2014

Passed with 900 with the help of this dump. Just one new question and 1-2 questions with somewhat different answers.

  • Jan 18, 2014
  • mrcheng2003
  • United Arab Emirates
  • Jan 17, 2014

Dumps Valid. Taken 16-Jan-2014. Got 850...

  • Jan 17, 2014
  • Rien Charest
  • Canada
  • Jan 17, 2014

esta valido, 5 preguntas nuevas!!

  • Jan 17, 2014
  • Rigby
  • Germany
  • Jan 16, 2014

Passed today with 900. Dump still valid. had just one or two questions from the dump with somewhat different answers and one new question. Study the dump and you should be fine. Good luck everyone.

  • Jan 16, 2014
  • Steve
  • United States
  • Jan 14, 2014

Took the exam today and got a 7XX (passed). I would say 80% of the questions are in the dump. Be ready to answer 4-5 cluster related questions

  • Jan 14, 2014
  • SQLGURRU
  • Australia
  • Jan 11, 2014

Dumps are 100%. Passed today with 900...Thanks Raman u r CHAMP

  • Jan 11, 2014
  • SadDBA
  • Brazil
  • Jan 09, 2014

100% Valid. Did the exam today(01-09-2014) and pass with 9xx. Just 1 new question.

  • Jan 09, 2014
  • Josh
  • Israel
  • Jan 09, 2014

I changed my mind re Q27. It should be A, since you can filter the Profiler so there is no problem to run it for an extended period. I don't think it's B since it is limited to blocked processes. And also not D since it's limited to deadlocks.

  • Jan 09, 2014
  • Kool
  • India
  • Jan 06, 2014

This is 100 % valid

  • Jan 06, 2014
  • Csabee
  • Hungary
  • Jan 03, 2014

This dump is valid. I passed today with 900.
One new question was only. You can see this question here: http://www.aiotestking.com/microsoft/2013/08/which-six-actions-should-you-perform-in-sequence/

  • Jan 03, 2014
  • Unknown
  • United States
  • Jan 02, 2014

Dump still valid. Took it in USA today, passed with 9xx.

  • Jan 02, 2014
  • Tester
  • United States
  • Jan 01, 2014

Anyone know if this is valid in US?

  • Jan 01, 2014
  • Ivan
  • United States
  • Jan 01, 2014

This dump is 95% valid in USA. Just passed it today, 9XX score.
2 New [PICK ANSWER] questions, 2 same [PICK ANSWER] questions, with somewhat different answers, and few questions with mixed order of answers.

Thank you man for the good work!

  • Jan 01, 2014
  • Mr.Cool
  • Kyrgyzstan
  • Dec 30, 2013

Hello People..!!
This dump is 100% valid in India.
Passed with 90%.

  • Dec 30, 2013
  • SQLadmin
  • Indonesia
  • Dec 30, 2013

This dump is valid in Indonesia. But there are much more drag and drop questions than in this dump. Visit http://www.aiotestking.com/microsoft/tag/70-462-v1/page/6/
for all the drag and drop answers. But be aware, some are wrong, but if you learned well you will know the anwers.

I learned by book and this test. Failed the 1st time but passed second time with 8xx.

  • Dec 30, 2013
  • Lee
  • Taiwan
  • Dec 30, 2013

@aitoufkir
Both answer "domain user" and "SQL user without login" are not exist in the real exam.

  • Dec 30, 2013
  • Lee
  • Taiwan
  • Dec 30, 2013

Valid. Passed today with score 883.

  • Dec 30, 2013
  • daniel
  • Mexico
  • Dec 27, 2013

this dump is 100% valid!

  • Dec 27, 2013
  • aitoufkir
  • Morocco
  • Dec 26, 2013

For question (Exam A;Q18),
I believe that the solution can be :

SQL user without login
======================================
Wath do you see?

  • Dec 26, 2013
  • Josh
  • Israel
  • Dec 26, 2013

Another reason Q37 should probably be COPY_ONLY is because in the instructions is says "You need to perform a FULL database backup..."

  • Dec 26, 2013
  • BIJU
  • United Arab Emirates
  • Dec 25, 2013

VALID.....PASSED....TODAY...7xx

  • Dec 25, 2013
  • no name
  • India
  • Dec 25, 2013

Cleared on 12/20/2013 with 800.

  • Dec 25, 2013
  • Masood
  • Pakistan
  • Dec 24, 2013

Dumps Valid 800 + mraks

  • Dec 24, 2013
  • Rafael
  • Brazil
  • Dec 24, 2013

Dump still validated in Brazil.

  • Dec 24, 2013
  • MadMan
  • Slovenia
  • Dec 20, 2013

Passed today. 100% valid. 1 new question.

  • Dec 20, 2013
  • Dinesh
  • Kyrgyzstan
  • Dec 19, 2013

Guys, is the dump still valid..
Suggestions please...

Thanks..

  • Dec 19, 2013
  • imbelani
  • South Africa
  • Dec 19, 2013

Valid in South Africa no new Questions

  • Dec 19, 2013
  • Fritz
  • Germany
  • Dec 19, 2013

Passed yesterday with 891. 85-90% valid in Germany. 50 questions, there were 7-8 new or modified ones. Nonetheless the dump is enough to pass; just read the comments and watch out for wrong answers.

  • Dec 19, 2013
  • Tshepo
  • United Kingdom
  • Dec 18, 2013

100% valid in south africa.No new questions.Thank Raman

  • Dec 18, 2013
  • Vito
  • Italy
  • Dec 18, 2013

Still valid.
50 questions and about 2 new questions.

  • Dec 18, 2013
  • MC
  • Italy
  • Dec 18, 2013

Dump valid. Passed on the 16th of Dec with 950!!
50 questions, no questions on Azure. Most questions from this dump, only 5-6 new questions with different answers.

Good luck guys! :)

  • Dec 18, 2013
  • John
  • Switzerland
  • Dec 18, 2013

Thanks suzie and Rafael for your feedback. suzie - What you said makes sense; the adding indexes part completely slipped my mind. Nonetheless thanks for the clarification :-).

Anyways, I've been thinking about what Josh from Israel said about Q27 and now I'm not completely sure. Any thoughts?
Also, there appears to be either a typo or wrong answer for Q17. Option B should be either EXECUTE AS 'dbo' (not EXECUTE AS USER = 'dbo') or it's wrong. If it's EXECUTE AS USER = 'dbo', I'm inclined to say that the answer is D. If it's EXECUTE AS 'dbo', I'm not sure whether the answer should be B or D. Anybody?

  • Dec 18, 2013
  • Ax
  • Italy
  • Dec 17, 2013

VALIIIIIDDDDD!!!!
Passed today with 883 (and MCSA earned!)
50 questions.
all in this dump.
Just pay attention to the answer's order... it was shuffled!!

Best greetings to all from Italy!
Ax

  • Dec 17, 2013
  • Svetlio
  • Bulgaria
  • Dec 17, 2013

Still valid. No new questions.

  • Dec 17, 2013
  • suzie
  • United States
  • Dec 17, 2013

John, I agree with your changes. Q48 ... transactional replication is the only option that would allow adding indexes to the db. You can't make changes to AG, mirroring or log shipping secondaries.

  • Dec 17, 2013
  • Kumar
  • Canada
  • Dec 16, 2013

Is this valid in North America? Thanks.

  • Dec 16, 2013
  • Rafael (Brazil)
  • Brazil
  • Dec 16, 2013

A agree with John in question 60 (Exam A). "doesn't have any column that refers to anything to do with blocking" and don't exist sessionid in table sys.dm_exec_sessions. The column that exists is the session_id.

  • Dec 16, 2013
  • John
  • Switzerland
  • Dec 16, 2013

Svetla - I think Q37 is wrong and should be COPY ONLY but Q38 should be Bulk because it says to import data in the minimum amount of time.

As for my concerns:
Q60 Exam A should be A (EXEC sp_who 60) because that SP has a blocking column while the sys.dm_exec_sessions DMV doesn't have any column that refers to anything to do with blocking.
Q48 - Can anybody explain this?
Exam 2 Q2: Does anybody have an answer to this? My guess would be: Merge, Snapshot, Merge, Transactional. Can anybody confirm? They are pretty vaguely worded so I'm not surely.
Exam 2 Q16: I agree with all the answers except for "Generating Alerts" SQL Profiler can't Generate Alerts. So I would say System Monitor should be in this box instead.

Can anybody please confirm ASAP?

  • Dec 16, 2013
  • Peter
  • Singapore
  • Dec 16, 2013

Still valid...Around 10 new questions. Passed with 8xx

  • Dec 16, 2013
  • Ron
  • Singapore
  • Dec 14, 2013

This dump are still Valid in Singapore, 10++ new questions and passed with 760++

  • Dec 14, 2013
  • Jitesh
  • India
  • Dec 13, 2013

Few new Que but dump is still Valid. Passed Today 833...

Thx

  • Dec 13, 2013
  • Josh
  • Israel
  • Dec 12, 2013

In Exam A Q27 - I think it should be B. There is no specific reference to deadlocks (TRACEON 1222), just to taking a long time... I agree that the Profiler doesn't fit, as the question is for 'an extended period'. Any thoughts?

  • Dec 12, 2013
  • Andrei
  • Russian Federation
  • Dec 12, 2013

Yes, the dump is still generally valid, but there are some new questions represented in the exam. Besides, some questions in the dump look wrong (for example, the Hotspot question). Usually I score about 970-980 points across the whole dump (90q), but today at the exam only 883... Good luck guys.

  • Dec 12, 2013
  • Ric
  • South Africa
  • Dec 11, 2013

Dump is still Valid in South Africa, 1 new question - passed 850

  • Dec 11, 2013
  • pino
  • Netherlands
  • Dec 10, 2013

For those who can not open the .vce file. The PDF file of Sajid Wasim is definitely valid. Pass with 866. I think there was 5 or 6 esy new question. So....Thanks brother Sajid.

  • Dec 10, 2013
  • Svetla
  • Germany
  • Dec 10, 2013

Also I think Q37 is wrong. The answer should be COPY_ONLY - L, as opposed to Transaction Log. Can anybody confirm that Q37 and 38 are wrong? Please feel free to challenge me :-).

  • Dec 10, 2013
  • Jemi
  • Egypt
  • Dec 08, 2013

Still Valid , got 9xx score , 4 new questions .

  • Dec 08, 2013
  • Turek
  • United States
  • Dec 07, 2013

None of the "Build List and Reorder" items will show up on VCE mobile for iPad or iPhone. I'm not sure about any other devices. So if you exclusively use VCE Mobile like me, make sure you study those on a PC or other platform where VCE will display them, there are 17 of them, all in exam B.

  • Dec 07, 2013
  • Dennis
  • United States
  • Dec 06, 2013

Passed Today - Test was back down to 50 questions, No Azure questions. Make sure you know the Answers because they were moved around a bit, but most of the questions were from this practice test.

  • Dec 06, 2013
  • Svetla
  • Netherlands
  • Dec 06, 2013

How come the answer for Q38 is L (Bulk Logged). Shouldn't it be FULL since you're guaranteed that no data is lost?

  • Dec 06, 2013
  • umi
  • Turkey
  • Dec 04, 2013

It is still valid. I saw a few new question. I got 8xx on 4th dec.

  • Dec 04, 2013
  • Alex
  • New Zealand
  • Dec 03, 2013

Dump is valid in NZ. I got 8XX on 3nd Dec,There are 50 questions,No questions from Azure.

  • Dec 03, 2013
  • Rafael Assis
  • Brazil
  • Dec 03, 2013

I think that question 17 in the exam B is wrong.

I maked the lab in home and only possible unable the created by sp_% procedure with option down:

Policy condition: '@Name NOT LIKE 'sp[_]%''

  • Dec 03, 2013
  • kamlesh
  • United States
  • Dec 03, 2013

Dump is valid in india. I got 9XX on 2nd Dec

  • Dec 03, 2013
  • Niana
  • United States
  • Dec 02, 2013

Still valid in US. Few tips..
1. Just choose level of knowledge as moderate in survey. I'm not sure if that's y I got all questions from this dumps.
2. No questions from Azure.
3. Focus on security - HA question, Deny & Revoke - Repl, AG..
4. Practice more on Exam B - Drag and drop
Good Luck !!

  • Dec 02, 2013
  • Niana
  • United States
  • Dec 02, 2013

Still valid in US. Few tips..
1. Just choose level of knowledge as moderate in survey. I'm not sure if that's y I got all questions from this dumps.
2. No questions from Azure.
3. Focus on security - HA question, Deny & Revoke - Repl, AG..
4. Practice more on Exam B - Drag and drop
Good Luck !!

  • Dec 02, 2013
  • Merican
  • United States
  • Dec 02, 2013

Dump Still valid, but expect 8 to 10 questions not on dump. got an 8xx, My test still had 70 questions, in USA on 11/30

  • Dec 02, 2013
  • Sajid Wasim
  • Bangladesh
  • Nov 30, 2013

Guys, I got some good dump. You can check this. Download from here:
https://dl.dropboxusercontent.com/u/14425563/70-462%20Exam%20Questions%20%26%20Answers.docx

  • Nov 30, 2013
  • Scotty from Czech republic
  • Czech Republic
  • Nov 30, 2013

Hi everybody, It looks like that Microsoft changed strategy. 50 q instead of 70q. No questions about Azure I think based on students complain in survey on the end of exam. 5 changed q and 5 new q. I passed exam 883 score Yesterday. Dump is still valid.

  • Nov 30, 2013
  • Hazem
  • Kuwait
  • Nov 28, 2013

dumb valid, passed today with score 800, total 50 questions in Kuwait, about 8 new questions out of 50

  • Nov 28, 2013
  • PULE
  • South Africa
  • Nov 28, 2013

This is dump 96% valid,i just passed with 9XX, there is only 2 new question.

  • Nov 28, 2013
  • Gopinath Ragothaman
  • Singapore
  • Nov 28, 2013

Hi took the test on Nov 28 2013 in Singapore, 48 out of 70 questions was from this .22 questions were new question.Passed with 887 marks.

  • Nov 28, 2013
  • karteina.d
  • South Africa
  • Nov 27, 2013

Hey guys, please direct me to the latest questions. thx.

  • Nov 27, 2013
  • Pass
  • Pakistan
  • Nov 27, 2013

Passed using this Dumps and got 887 marks, how ever almost 20 new question were there.

  • Nov 27, 2013
  • tip
  • United Kingdom
  • Nov 26, 2013

Passed. As others mentioned approx 20 new questions.
New questions included three mentioned from below comments
1)getting "error 5" (access denied) on pull partner
2.You plan to migrate the db to azure. you verify that all objects are valid for azure sql database.
You need to ensure that users and logins are migrated to azure.
what should u do?
A Use the Copy Database wizard
B Use the Database Transfer wizard
C Use the SQL Management Studio to deploy the db to azure
D Back up the database from the local server and restore it to azure
3) You need to ensure that users and logins are migrated to azure.
what should u do?
A Use the Copy Database wizard
B Use the Database Transfer wizard
C Use the SQL Management Studio to deploy the db to azure
D Back up the database from the local server and restore it to azure
4) A single instance of SQL Server is installed on the cluster.
An additional node named Node C has been added to the existing cluster.
You need to ensure that the SQL Server instance can use all nodes of the cluster. What should you do?
No Run the Add Node to SQL Server Failover Cluster Wizard on Node C option. There was use config file from Node B option.
5)One question had different punch line ,You administer all the deployments of Microsoft SQL Server 2012 in your company. You have two servers in the same data centre that hosts your production database. You need to ensure that the database remains available
If there is a power outage at the site, the Secondary is configured and ready for use without further user configuring.

6) database fails at 22:10, restore of tail log fail, need to restore transactional database with minimum data lost, which option.

7) restore the database using SSMS, check/drop down the correct options from the UI screen.
8)You need to minimize memory used by processes , two option, check the correct box. config min memory or config max memory.
9)Two questions on moving files to disks, you have three disk (different types (raid 1, raid 10), sizes) which files should be stored of which. 1 question had files types option of database data files,database log files,tempdb log files, tempdb data files.
10) You need to diagnose deadlocks over long period of time, must not effect performance,many options but included Extended Events and SQL Profiler. Went with X Events.
11) Question on roles. Stored procedure, All users must be able to run procedure and must be able to read all tables, minimum permissions,
12)Which features should be installed with SQL Server to do certain tasks, UI question (checking the correct options)

Sorry about the lack of info and wording on questions but just can't remember.
Hope it helps you out some what.

Thanks for all the help guys. Good luck.

  • Nov 26, 2013
  • DBAtadzislaw
  • Poland
  • Nov 26, 2013

Failed today. Only 10% of questions from this dump appeared on my exam. Please create new dump.

Not valid in Poland.

  • Nov 26, 2013
  • anon
  • United Kingdom
  • Nov 26, 2013

This dump still largely valid, passed today with 8** in UK. Thanks for the dump and the comments.
As others have said, approx 20 to 25 unseen questions out of 70, a few on migrating to Azure and existing questions reworded slightly.

As always with Microsoft there's often more than 1 correct answer, look for the subtle clue 'with minimum permissions' or 'minimum administrative effort' - normally tells you which of the correct answers they're looking for.

Emphasis on:
-Backup and restore - know differences between backup type/backup options/recovery models (also exam includes tail logs which dump does not)
-Backup/restore DB vs detach/attach DB (1 question asks about moving from 2005 to 2012, with scheduled downtime to test, how to do this as quick as possible - detach/attach is quicker and acceptable due to scheduled downtime).
-Clustered/Non Clustered Indexes
-Contained databases (full vs partial?)
-Azure (what tools to administer, query & data)

Good luck all.

  • Nov 26, 2013
  • Umar
  • Pakistan
  • Nov 26, 2013

Dumps are still valid, passed with 887. but 20+ question were new.

  • Nov 26, 2013
  • John
  • South Africa
  • Nov 26, 2013

Took exam on Thursday, had about 50% new questions..
Know your work!

  • Nov 26, 2013
  • Leda
  • Albania
  • Nov 25, 2013

Could anyone help with new 20 questions? Why it is so long, no one updates with a new dump,hope someone will do soon. Thanks

  • Nov 25, 2013
  • Avi
  • United States
  • Nov 25, 2013

Passes exam on 11/25, 780 Only 50% valid.

  • Nov 25, 2013
  • Muhammad Umar Saleem
  • Pakistan
  • Nov 25, 2013

These dumps are valid, Just passed 70-462 with 887, but Exam had total 70 Questions and to be very exact, 23 Questions were new(not in this Dumps)

  • Nov 25, 2013
  • x2x
  • Poland
  • Nov 25, 2013

I passed today with score 831. Dump still valid. New questions from: migration to azure,new server roles on azure,locating mdf,log,tempdb files on storage (raid10,raid5). Good luck

  • Nov 25, 2013
  • Mike
  • Sweden
  • Nov 24, 2013

Any updates on this exam? Going to take it on tuesday.

  • Nov 24, 2013
  • Anny
  • Sweden
  • Nov 21, 2013

Check out this link: http://msdn.microsoft.com/en-us/library/windowsazure/ff394116.aspx

Good Azure info

  • Nov 21, 2013
  • jb
  • United Kingdom
  • Nov 20, 2013

Still valid. Passed with 8xx.
Some Azure Q's but relating to Contained DB environments. Make sure you know the Azure owners (dbmanager, loginmanager)

Also got a question something about a web site environment and you need to make sure that the SQL installation allowed Basic Integration Services, Backup Compression, Low overhead costs. What installation version would you choose
A: SQL Express with Advanced Services
B: SQL Standard
C: Web Edition
D: SQL Express with Tools

Answer is B: Standard, as this is the only version from the list that allows Compression Backups.

  • Nov 20, 2013
  • Damian
  • United States
  • Nov 19, 2013

Around 30 new questions. Passed today but was quite hard. Good luck!

  • Nov 19, 2013
  • jim
  • United Kingdom
  • Nov 19, 2013

Dump is still valid. Passed with 8xx
There were about 12-15 new questions. There were 4 Azure questions but these were either what Azure roles (dbmanager, loginmanager) then match the other ones to SQL Database Roles. Or related to contained databases, which is covered in the MS Training Kit.
Also a question about what version of SQL server version to install to meet requirements for a web application that
Allow for basic Integration features. Allow Compression and keep costs down. Choose from
A. Standard Edition
B. Express With Tools
C: Express with Advanced Services
D. Web Edition

  • Nov 19, 2013
  • mili
  • United States
  • Nov 18, 2013

Passed with 775.this dump is still valid. i had 13-15 new questions ,mostly on Azure. some of the questions from the dump was the same but the answers(options) were different.

  • Nov 18, 2013
  • fry
  • Germany
  • Nov 18, 2013

Got nearly 800 pts. and 23 new questions (3 with azure).

  • Nov 18, 2013
  • pzerounoc
  • Italy
  • Nov 17, 2013

Please post the latest version of this dump i have this exam in few days. ty

  • Nov 17, 2013
  • GuyVer
  • South Africa
  • Nov 15, 2013

Passed today. Thanks a lot guys. But it was hectic. Got a total of 70 questions.

Two Azure questions. Three questions with relation to tempdb, userdb and raid. Clustering questions.

I would say the dump is about 60% valid for the exam that i wrote today. Just glad that i passed. Once again thanks for the dump.

  • Nov 15, 2013
  • ololo
  • Germany
  • Nov 15, 2013

This dump is valid. Passed yesterday in Europe with 8xx. However 20 new questions, but not actually hard. So do the reading!

  • Nov 15, 2013
  • ololo
  • Germany
  • Nov 15, 2013

This dump is valid. Passed yesterday in Europe with 8xx. However 20 new questions, but not actually hard. So do the reading!

  • Nov 15, 2013
  • an
  • Vietnam
  • Nov 15, 2013

this dump is still valid, exam has ~20 new question. I got 8xx today.

  • Nov 15, 2013
  • mili
  • United States
  • Nov 14, 2013

@Sajid Wasim .thank you for the pdf. so all the answers in the pdf are right answers ,right?

  • Nov 14, 2013
  • anon
  • United Kingdom
  • Nov 14, 2013

Can anyone confirm if answer for Exam D Q16 is wrong?
It says to use the ExtendedEvents tool to Troubleshoot the cause of high page_io latch. Would it not be System Monitor? As you can use SQLServer:Wait Statistics performance object in system monitor to find information about wait status for Page IO latch waits.

Can anyone confirm if the answer for this should be System Monitor instead of Xevents?

  • Nov 14, 2013
  • Sajid Wasim
  • Bangladesh
  • Nov 14, 2013

Download the pdf version from here:
https://dl.dropboxusercontent.com/u/14425563/Microsoft.Braindump2go.70-462.v2013-08-12.by.Raman.90q.pdf

  • Nov 14, 2013
  • KKK
  • Hong Kong
  • Nov 14, 2013

Took the exam yesterday on 13/Nov. Passed with 850 score
about 10 new question (4 of them are azure)
about 5 questions change from multiple select to Drap and Drop questions

  • Nov 14, 2013
  • mili
  • United States
  • Nov 13, 2013

hi everyone,
I am taking this exam in 2 days. Does anyone have the list of newly added questions-answers.

Thanks in advance!!!!

  • Nov 13, 2013
  • SanFran1122
  • United Kingdom
  • Nov 13, 2013

Took today, This is not valid, hardly any of the 70 questions were from this dump. Lots of new ones.

  • Nov 13, 2013
  • Anny
  • Sweden
  • Nov 12, 2013

Got 5XX today (only used the training kit and youtube videos) and found the test to be quite difficult. Many drag and drops (around 10), 4 azure related questions(!!).

  • Nov 12, 2013
  • jim
  • United Kingdom
  • Nov 12, 2013

I took that from a Transcender dump if the option was Transaction_Log not Transaction Log. Sorry for the confusion. Still think it will be COPY_ONLY answer.

  • Nov 12, 2013
  • jim
  • United Kingdom
  • Nov 12, 2013

@Albert @Jerzy
COPY_ONLY is correct.

Transaction_log - is no longer used with the BACKUP statement. To back up a transaction log, you must use the BACKUP LOG statement, not BACKUP TRANSACTION_LOG. So answer J is wrong in the VCE

  • Nov 12, 2013
  • Anon
  • United Kingdom
  • Nov 10, 2013

Passed 9xx, 1 azure question related to contained databases. About 15 new questions. Many existing ones have had answers shifted around.

  • Nov 10, 2013
  • jim
  • United Kingdom
  • Nov 10, 2013

Reply to Mike's question relating to improving query performance. I would choose
1. Cost Threshold for Parallelism
2. Max degree of Parrallelism

Anyone agree/disagree?

  • Nov 10, 2013
  • jim
  • United Kingdom
  • Nov 10, 2013

reply to mikes replication error 5 question. According to MS you should do the following:
1. Create a local Windows account on both the Publisher and Subscriber that has the same username and password.
2. Use this account for the Merge Agent process account and have the connections to the publisher and distributor impersonate the agent process account.
3. Ensure the account has the permissions required in Replication Agent Security Model.

This approach is covered in the section Use Windows Authentication to Set Up Replication Between Two Computers Running SQL Server in Non-Trusted Domains

  • Nov 10, 2013
  • Sean-MCT
  • South Africa
  • Nov 10, 2013

Best VCE of the bunch. Others have more errors.

  • Nov 10, 2013
  • mike
  • Canada
  • Nov 09, 2013

Came across the following question - I already passed, so someone else can research the answer. This is not the exact phrasing, but as long as you understand the options, I am sure you will be able to answer the question.

Question about slow performance of queries. If you right-click the instance and select properties, and then click the Advanced section, what options can be used to improve the performance of queries? (one or more selections)

Choose among:
1. blocked process threshold (currently set to 0)
2. Optimize for ad-hoc workload (currently set to True)
3. Parallelism Cost Threshold
4. Parallelism Max Degree
5. May have been other options as well?

  • Nov 09, 2013
  • Emile
  • Netherlands
  • Nov 07, 2013

Hi, is anyone familiar with the questions of measureUp.com ? These questions are much harder than this dump.

  • Nov 07, 2013
  • Frank
  • Poland
  • Nov 06, 2013

I pass the exam with 9XX. This dump is valid. Exactly 23 new questions.

  • Nov 06, 2013
  • Jerzy
  • Netherlands
  • Nov 06, 2013

Hi there, I haven't done a exam for a few years and I have a question. If there is a question that says "choose all that apply", will there be a number how much to apply like in "visual certexam manager" ?
In "visual certexam manager" in the lower left corner there is a hint "select x choices".

  • Nov 06, 2013
  • mike
  • Canada
  • Nov 05, 2013

New replication question - getting "error 5" (access denied) on pull partner. SQL services using virtual or local accounts. How to fix? Cannot remember options for answer - but I'm sure someone can research the error.

  • Nov 05, 2013
  • mike
  • Canada
  • Nov 05, 2013

Update on question: alternate valid answer for the following question is "DatabaseMailUserRole".

====
You are creating an application that will connect to the AgentPortal database by using a SQL login named AgentPortalUser.
Stored procedures in the database will use sp_send_dbmail to send email messages.
You create a user account in the msdb database for the AgentPortalUser login.
You use the Database Mail Configuration Wizard to create a Database Mail profile.
Security has not been configured for the Database Mail profile.
You need to ensure that AgentPortalUser can send email messages.
What should you do?

  • Nov 05, 2013
  • Mike
  • Canada
  • Nov 05, 2013

Regarding the following question, the list of choices are incorrect - the answer in the VCE uses a selection that is not on the exam . "Restore the full backup on SQL 2012". The only restore options are either "Restore the VSS backup on SQL 2012" or "Restore the database backup and transaction log backup on SQL 2012".

This will change the answer listed in the VCE, which currently includes the step "Restore the full database backup on SQL 2012".

===
You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server 2005 instance named SQL2005 and a development SQL Server 2012 instance named SQL2012.

The development team develops a new application that uses the SQL Server 2012 functionality.

You are planning to migrate a database from SQL2005 to SQL2012 so that the development team can test their new application.

You need to migrate the database without affecting the production environment.

Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
===

  • Nov 05, 2013
  • CK
  • New Zealand
  • Nov 05, 2013

Passed today with 904, hard exam! took a while and was cautious from the comments. Read the questions! some of mine sounded similar to the dump questions but had different answers

But with the dump i think i might have passed anyway. had about 15-20 new questions. Cant remember any though

Definitely wouldnt have passed without this, do your reading! It will help you answer the new questions and any thing MS have changed

  • Nov 05, 2013
  • MwendwaJK
  • Kenya
  • Nov 04, 2013

passed with 850. dump valid but there some new questions on azure

  • Nov 04, 2013
  • SuGu
  • Poland
  • Nov 01, 2013

Still valid - passed this week with 9xx. Many new questions (~20).

  • Nov 01, 2013
  • nav
  • India
  • Nov 01, 2013

Still valid dump. passed with 8xx on 31st oct from india.

Q) How to transfer all the logins from sql 2005 to 2012 ?
A) Using Transfer Login Task in ssis

Q 18) You use a contained database named ContosoDb within a domain.

You need to create a user who can log on to the ContosoDb database.

You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations.

Which type of user should you create?


A.User mapped to a certificate
B.SQL user without login
C.Domain user
D.SQL user with login

Think c. Coz as per dump option B is not der in exam paper.

Concentrate on high data availablilty features and SQL Azure. With this dump we can easily score 700.

  • Nov 01, 2013
  • Albert
  • Belgium
  • Oct 31, 2013

@Jerzy:
Wrong answer. The good one is L. COPY_ONLY
cf Kat from Macau post
Others, Am I right?

  • Oct 31, 2013
  • Jerzy
  • Netherlands
  • Oct 31, 2013

Can anyone explane this question 56:
These data load operations must occur in the minimum amount of time. A full database backup is performed every Sunday at 10:00 hours.
Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.

On Wednesday at 10:00 hours, the development team requests you to refresh the database on a development server by using the most recent version.

You need to perform a full database backup that will be restored on the development server.
Which backup option should you use? A. NORECOVERY
B. FULL
C. NO_CHECKSUM
D. CHECKSUM
E. Differential
F. 8ULK_LOGGED
G. STANDBY
H. RESTART I. SKIP
J. Transaction log
K. DBO ONLY
L. COPY_ONLY M. SIMPLE
N. CONTINUE AFTER ERROR

Correct Answer: J
They ask "which backup OPTION should you use"
Transaction log is not an otion but a backup type.
I would say a "copy only backup".

  • Oct 31, 2013
  • cc
  • South Africa
  • Oct 30, 2013

Any one know if these answers are correct below?

You create a new user named UserA. You need to ensure that UserA is able to create SQL Server Agent jobs and to execute SQL Server Agent jobs. To which role should you add UserA?

A. Securityadmin
B. RSExecRole
C. SQLAgentUserRole
D. DatabaseMailUserRole

think C
---
You administer a database that has User A, B and C
User A must be able to create new tables and stored procedures, User B must be able to select, update, delete and insert data, User C must be albe to provide windows logins to the database

db_accessadmin
db_ddladmin
db_datawriter
db_datareader
db_owner

To which role or roles should you add the users?

A = ddladmin
B=datawriter, datareader
C=accessadmin

  • Oct 30, 2013
  • cc
  • South Africa
  • Oct 30, 2013

Any one know if these answers are correct below?

1. u need to install the Power View Components on a stand alone server. Which three actions should you perform (and sorting)?
Possible choices:
A Install SQL 2012 Analyse Services
B Install SQL 2012 Reporting Services
C Install SQL 2012 Database Engine and PowerPivot for Sharepoint
D Configure SQL Server Reporting Services and Addin in sharepoint mode
E Configure SQL Server reporting services in native mode

my choice was: CBD

2.u plan to migrate the db to azure. you verify that all objects are valid for azure sql database.

u need to ensure that users and logins are migrated to azure.
what should u do?
A Use the Copy Database wizard
B Use the Database Transfer wizard
C Use the SQL Management Studio to deploy the db to azure
D Back up the databasae from the local server and restore it to azure

my guess: C

3 u maintain several dbs on a 64 bit ms sql 2005 instance
u need to migrate the dbs to sql 2012 on the same server. you also need to ensure functionality in sql 2012 can be used in the db after migration.
what should u do? (each correct answer presents part of the solution)
A Perform an in-place upgrade to 64-bit in sql 2012
B Perform a side by side installation of a 64 bit sql 2012
C Perform a side by side installation of a 32 bit sql 2012
D Detach the old instance and attach it to the new one
E Change the compatibility level of the db
my choices: BDE

  • Oct 30, 2013
  • Albert
  • Belgium
  • Oct 30, 2013

Exam B , Q3 :
I was wrong . The answer is correct.
cf. training kit book chapter 7 page 283

Sorry for the bad post

  • Oct 30, 2013
  • Albert
  • Belgium
  • Oct 30, 2013

Other question:
Exam B , Q3 : I'm not sure the dump is right .
When restoring the transaction log backup. I think that you have to do it WITH RECOVERY .if NORECOVERY (dump response), the db stays unavailable.

What is your opinion???

  • Oct 30, 2013
  • Albert
  • Belgium
  • Oct 30, 2013

@John,
For question Exam B Q18 :
In my opinion
1 ) execute BCP tool
2 ) Perform full backup
3 ) perform a database log backup
4 ) configure database to use full recovery model
5 ) configure database to use bulk log recovery model

3-5-1 dump is right.
The database has FULL and log backups.
So, if you want to rollback before the bulk insert:
-Recover the full backup
-Recover all backup logs done after full backup + the log backup done in (3)

The bulk-logged recovery model is set to follow the requirement :
The database transaction log is minimally affected.



Guys, am I wrong?

  • Oct 30, 2013
  • Albert
  • Belgium
  • Oct 30, 2013

@John:
I tested both on my server.
The dump is wrong. the good answer is NOT LIKE.
When I configured with LIKE, I can only create stored procedures with sp_% in the name. So, the opposite of what I need to do

  • Oct 30, 2013
  • Avi
  • Israel
  • Oct 30, 2013

Around 45-50 questions are from this dump.
Had a drag and drop question about configuring max memory, had a hard time to rememember if show adv. options is needed(it is).
Had a question that looked like - "create a private mail" answer question in this dump but without that option, I've answered - add to MailSomething role.
Had a similar question about transfering from 2005 to 2012 -full backup at 2005 -but then there was only full and log(? from where) restore at 2012 option.
There was a multiple choise question about sql (mirror ?) deployment with minimum security problems, d&d question what are azure and what are sql roles I've chose dbmanager and another dbSomething for azure all others for sql.
D&D audit question similar to question in the dump but with 2 similar "create audit specification" options only difference is execute as dbo/public, had no clue there.
Got 800+, bottom line is that this dump+little knowledge is still enough to pass, thanks to everyone who is posting questions here ang GL to everyone else!

  • Oct 30, 2013
  • John
  • Hong Kong
  • Oct 30, 2013

Another is Bulk Insert

http://social.technet.microsoft.com/Forums/sqlserver/en-US/c3eb3fbf-578e-4e64-a33d-e27632455b14/070462-bulk-insert?forum=sqldocumentation

You need to ensure that the following requirements are met during the bulk operation:
The database transaction log is minimally affected.
The database is online and all user transactions are recoverable. All transactions are fully recoverable prior to the import.

1 ) execute BCP tool
2 ) Perform full backup
3 ) perform a database log backup
4 ) configure database to use full recovery model
5 ) configure database to use bulk log recovery model

3->4->1 or 3->5->1 ??

or just "forget reality and just answer the question the way MS wants you too."

  • Oct 30, 2013
  • John
  • Hong Kong
  • Oct 30, 2013

About the condition is "Like" or "NOT Like"

http://social.technet.microsoft.com/Forums/sqlserver/en-US/6222b41a-fd51-47bf-ad4c-ccf06aa39b8e/070462-enable-condition?forum=sqldocumentation

In the real world is "NOT Like" ?
In the exam is "Like" ?

No idea.

  • Oct 30, 2013
  • Capoeira
  • Canada
  • Oct 29, 2013

Guys, Albert is right. I tested both conditions. The correct condition is "NOT Like".

  • Oct 29, 2013
  • John
  • Canada
  • Oct 29, 2013

Correction: I may be wrong. My assumption was that the "On Change: Prevent" would prevent a condition that matches the filter, but maybe it prevents any changes that do not match the filter. Trying to research, but not finding a definitive answer .

  • Oct 29, 2013
  • John
  • Canada
  • Oct 29, 2013

Albert, "Operator to LIKE" is correct.

You have to consider the evaluation mode.

"On Demand" evaluates the policy when directly specified by the user.

"On Change: Prevent" is an automated mode that uses DDL triggers to prevent policy violations.

  • Oct 29, 2013
  • Albert
  • Belgium
  • Oct 29, 2013

Error on exam B ( drag and drop) question 8 :
users are UNABLE to create sp with sp_ %
==>for the condition : operator NOT LIKE ! (wrong answer says LIKE)
It must be LIKE if users are only able to create sp with sp_%

  • Oct 29, 2013
  • Tony
  • United States
  • Oct 29, 2013

check the below link, its have the correct answers

http://www.mcseanswers.com/category/70-462-dumps

  • Oct 29, 2013
  • Chung L
  • Australia
  • Oct 28, 2013

Thanks guys! Passed it last week with 887 and most is still valid.
A bunch, +/-15 of new questions. Some questions only look the same but you need to read carefully as the answers are different.Some questions are completely different.
big thanks to b from Germany - Oct 09 2013, post, test from Austria, anon from United Kingdom - Oct 22 2013 and Baloght from Unknown - Oct 24 2013, for putting the different questions and outlining the difference.
Have a careful read on Azure management and security, user security rights, upgrading 2005 and 2008R2 servers and dbs to 2012 and you will pass it.
Good luck!

  • Oct 28, 2013
  • Paulina
  • Oct 28, 2013

Guys, I am planning to write an exam this Friday, please update the new staff. I'd appreciate it.

  • Oct 28, 2013
  • Avi
  • Israel
  • Oct 28, 2013

Is there a place where I can find the most recent dump?
There is no information about SQL-Azure in 70-462 Training Kit.

  • Oct 28, 2013
  • Baloght
  • Hungary
  • Oct 24, 2013

Passed exam with 850.
Thanks the help and questions. Help me a lot.
There was appr. 20-25 New questions:
You know Azure login,
you Plan to deploy Database to Azure, which components have to install the user, if he want to managed some queris and others in database
You have to know the index (clustered, non-clustered)
Drag and Drop question that which embedded users exists in Azure and which Sql local
There was a question that the table has some non-clustered index, and the query performance slow, you have to managed the index (Drop index, create index, rebuild index, .)
You have to know the SQL login settings, set default Database to user, set enforce password policy, .
You have to put 2008 32bit Database to same server 2012 64bit instance ( dettach, attach, set comp. level)

Good luck!!!

  • Oct 24, 2013
  • Zoubi
  • Jordan
  • Oct 24, 2013

Passed today with 793,More than 28 new questions out of 70 questions.
Good look

  • Oct 24, 2013
  • Diya
  • Jordan
  • Oct 23, 2013

Passed today with 868, round 30 new question.

  • Oct 23, 2013
  • anon
  • United Kingdom
  • Oct 22, 2013

Passed. Tough exam!
About 40% new questions, some rearranged, inverted questions (e.g same scenario or answers as dump but with different punch line/question line),
New questions nearly all of the drag and drop or UI type
Couple of UI based questions, it shows you a screenshot, you select the correct item in a drop down and/or check the correct options to achieve an outcome

Revise SQL and scenarios for using:
Filtered Indexes
Contained databases (configuration, permissions, full/partial)
Migration to Azure (standard DBSQL , switch to contained DB including users, migrate to Azure)
Azure roles (dbmanager, loginmanager)
Server/database roles, differences between them, SQL to create them
Server/database auditing including writing the SQL to create and alter them
Backup and restore, including tail logs
Side-by-side installation and when to use backup/restore over detach/attach

I used 70-462 self paced training kit MeaureUp tests, dumps from here (some have different q's so make sure you go through all dumps not just this one), and some random stuff I found online. I normally also use Transcender and am definitely thinking about getting it for 70-463.

Could I have passed without these dumps? No, even if the questions don't appear (and some of the answers are wrong) they guide you in the right direction and definitely prepare you for the test, so keep them coming please!

  • Oct 22, 2013
Pages:  1 2  [>]  [>>]

Add Comments

Only Registered Members Can Download VCE Files or View Training Courses

Please fill out your email address below in order to Download VCE files or view Training Courses. Registration is Free and Easy - you simply need to provide an email address.

  • Trusted By 1.2M IT Certification Candidates Every Month
  • VCE Files Simulate Real Exam Environment
  • Instant Download After Registration.
Please provide a correct e-mail address
A confirmation link will be sent to this email address to verify your login.
Already Member? Click Here to Login

Log into your ExamCollection Account

Please Log In to download VCE file or view Training Course

Please provide a correct E-mail address

Please provide your Password (min. 6 characters)

Only registered Examcollection.com members can download vce files or view training courses.

Registration is free and easy - just provide your E-mail address. Click Here to Register

SPECIAL OFFER: GET 10% OFF

ExamCollection Premium

ExamCollection Premium Files

Pass your Exam with ExamCollection's PREMIUM files!

  • ExamCollection Certified Safe Files
  • Guaranteed to have ACTUAL Exam Questions
  • Up-to-Date Exam Study Material - Verified by Experts
  • Instant Downloads
Enter Your Email Address to Receive Your 10% Off Discount Code
A Confirmation Link will be sent to this email address to verify your login
We value your privacy. We will not rent or sell your email address

SPECIAL OFFER: GET 10% OFF

Use Discount Code:

MIN10OFF

A confirmation link was sent to your e-mail.
Please check your mailbox for a message from support@examcollection.com and follow the directions.

Next

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.