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 what you can do to complete the technical tasks the following. The percentages indicate the relative weight of every major topic area for the exam. The better the percentage, the more questions you'll probably see on that content area on the exam. View training videos regarding the selection of question types on Microsoft exams.

Please note that the questions may test, and can not restricted to, the topics described in the bulleted text.

Have you got feedback about the relevance with the skills measured with this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and longevity of the certification process. Note that Microsoft will not respond straight away to your feedback. We thank you for your input in ensuring the quality of the Microsoft 70-461 Certification program.

If you have concerns about specific questions about this exam, please submit an examination challenge.

If you have other questions or feedback about Microsoft Certification exams or concerning 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 had been 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 Launch

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. Work at your personal pace through a group of lessons and practical exercises, then assess your skills 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 two or more experience, that are wanting to validate their knowledge and skills on paper queries.

70-461 Exam Preparation

Additional information about exams
Our recommendation is that you review this 70-461 exam preparation guide completely and become acquainted with the resources on this internet site before you schedule your exam. See the Microsoft Certification exam overview for details about registration, videos of typical exam question formats, and also other preparation resources. For information on exam policies and scoring, begin to see the Microsoft 70-461 Certification exam policies and FAQs.

This preparation guide is susceptible to change without notice without prior notice at really the only discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not know the format through which exams are presented. Please make use of this preparation help guide plan for the 70-461 exam, irrespective of its format. That may help you plan for this exam, Microsoft recommends that you've hands-on experience with the product so that you utilize specified training resources. These training resources do not really cover every one of the topics indexed by the "Skills measured" section.

For details about 70-461 Sample Questions take a look at this popular site.