Querying Microsoft SQL Server 2012/2014 Exam (70-461)

? Published: June 11, 2012
? Languages:English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil)
? Audiences:IT professionals
? Technology: Microsoft SQL Server 2012/2014
? Credit toward 70-461 certification: MCSA, MCSE
? Price: $165.00 USD

Skills measured
This 70-461 exam measures you skill to accomplish the technical tasks listed below. The percentages indicate the relative weight of each one major topic area about the exam. The higher the percentage, the harder questions you are likely to see on that content area on the exam. View video lessons regarding the selection of question types on Microsoft exams.

Please note that the questions may test, and often will 't be restricted to, the themes described inside the bulleted text.

Do you have feedback about the relevance with the skills measured for this exam? Please send Microsoft your comments. All feedback will likely be reviewed and incorporated as appropriate while still maintaining the validity and longevity of the certification process. Note that Microsoft won't respond right to your feedback. We thank you for input in ensuring the standard of the Microsoft 70-461 Certification program.

For those who have concerns about specific queries about this exam, please submit an exam challenge.

When you have other questions or feedback about Microsoft Certification exams or in regards to the certification program, registration, or promotions, please contact your Regional Service Center.


In December 2015, this exam was evaluated for applicability to both SQL Server 2012 and SQL Server 2014. It absolutely was determined that no updates to exam objectives were required.

? Create database objects (20-25%)
? Work with data (25-30%)
? Modify data (20-25%)
? Troubleshoot and optimize (25-30%)

Preparation options
Instructor-led training
20461C: Querying Microsoft SQL Server (five days)

Find out more:

Self-paced training
Querying Microsoft SQL Server 2012 Databases Jump Start

Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012
Published: Published: November 2012

Ace your preparation for Microsoft Certification Exam 70-461 using this 2-in-1 Training Kit from Microsoft Press. Just work at your individual pace by way of a number of lessons and practical exercises, then assess the with more experience tests on CD-featuring multiple, customizable testing options.

Who must take this exam?
This exam is intended for SQL Server database administrators, system engineers, and developers with 2 or more years of experience, that need to validate their knowledge and skills on paper queries.

70-461 Exam Preparation

More info about exams
We recommend that you review this 70-461 exam preparation guide in its entirety and familiarize yourself with the means on this website when you schedule your exam. Start to see the Microsoft Certification exam overview for information regarding registration, videos of typical exam question formats, as well as other preparation resources. For information on exam policies and scoring, start to see the Microsoft 70-461 Certification exam policies and FAQs.

This preparation guide is subject to change at any time without prior notice and also at really the only discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft will not identify the format in which exams are presented. Please make use of this preparation self-help guide to get ready for the 70-461 exam, no matter its format. That may help you plan this exam, Microsoft recommends which you have hands-on exposure to the product or service so that you use the specified training resources. These training resources do not really cover all the topics listed in the "Skills measured" section.

Check out about 70-461 Study Guide explore the best web page.