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 your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area around the exam. The better the percentage, the greater questions you may well see on that content area on the exam. View video tutorials regarding the number of question types on Microsoft exams.
Please be aware that the questions may test, and often will not be restricted to, the topics described within the bulleted text.
Have you got feedback in regards to the relevance from the skills measured for 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. Be aware that Microsoft is not going to respond directly to your feedback. We thank you for input in ensuring the caliber of the Microsoft 70-461 Certification program.
When you have concerns about specific queries about this exam, please submit an examination challenge.
When you have other questions or feedback about Microsoft Certification exams or regarding 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 turned out 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)
Learn more:
Self-paced training
Querying Microsoft SQL Server 2012 Databases Ramp up
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 type of 2-in-1 Training Kit from Microsoft Press. Act on your own personal pace via a group of lessons and practical exercises, and 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 two or more years of experience, that are wanting to validate their knowledge and skills written queries.
70-461 Exam Preparation
More details about exams
We recommend that you review this 70-461 exam preparation guide as a whole and become acquainted with the resources on this website before you decide to schedule your exam. Understand the Microsoft Certification exam overview for information regarding registration, videos of typical exam question formats, along with other preparation resources. For info on exam policies and scoring, start to see the Microsoft 70-461 Certification exam policies and FAQs.
This preparation guide is at the mercy of change anytime without prior notice at the only real discretion of Microsoft. Microsoft exams could include adaptive testing technology and simulation items. Microsoft won't know the format through which exams are presented. Please utilize this preparation guide to plan for the 70-461 exam, irrespective of its format. To assist you plan for this exam, Microsoft recommends that you've hands-on exposure to the product and you use the specified training resources. These training resources do not really cover each of the topics indexed by the "Skills measured" section.
More information about 70-461 Sample Questions view our web site.