Home | Exam Information
Home | Microsoft Exam information, study guides, training courses, help and advice.
Copyright © Accelerated Ideas 2005-2018

70-586 MCTS SQL Server 2011 Exam Overview

Microsoft have announced that the next version of the MCTS Microsoft SQL Server Implementation and Maintenance exam will be 70-586. This exam contains subjects from the new SQL Server 2011 (v11).

The exam will closely follow the subject material for SQL 2008 with exception that it relates specifically to 2011. Any new changes in SQL 2011 will be included in the exam, so make sure you know them well! Microsoft typically recommend that students wanting to take this exam have 2 to 3 years experience of using SQL Server and have jobs where database administration is their main responsibility.

This includes:

  • IT generalists who work in environments in which SQL Server 2011 is part of an overall solution
  • IT professionals who manage systems that run SQL Server 2011
  • IT professionals who work with third-party applications that are built on SQL Server 2011
  • Developers who build applications that use SQL Server 2011

When you pass exam 70-586 you will complete the requirements for the MCTS SQL Server 2011 Implementation and Maintenance certification.

The 70-586 exam will contain questions relating to these aspects of SQL Server 2011:

  • Installing and Configuring SQL Server 2011
  • Maintaining SQL Server Instances
  • Managing SQL Server Security
  • Maintaining a SQL Server Database
  • Performing Data Management Tasks
  • Monitoring and Troubleshooting SQL Server
  • Optimizing SQL Server Performance
  • Implementing High Availability

Note: There has been no official word on the naming of the next version of SQL Server, but it is widely expected to be 2011.

Popular Sections

Free Practice Tests

We have a large selection of free Microsoft practice tests to help you prepare for your exam
Microsoft Practice Tests


Azure and Amazon AWS Certification Salaries
Azure and Amazon AWS Certification Salaries

Few would argue that cloud certifications are on the rise. There's an increasing number of job opportunities for those with skills in cloud architecture and infrastructure for both Amazon AWS and Azure. A recent market report highlighted that..
Do you need to recertify your Microsoft exams? Recertification for MCSE and MCSA Explained
Do you need to recertify your Microsoft exams? Recertification for MCSE and MCSA Explained
Microsoft have updated their recertification process which requires IT professionals to renew their MCSE and MCSD certifications every 2-3 years to stay up to date. Recertification exams, just like any other exam, are published on a regular basis as
SQL Server 2014 Exam Numbers and Certifications
SQL Server 2014 Exam Numbers and Certifications
Microsoft have confirmed the new SQL Server 2014 certifications and associated exams. As the new version of SQL Server is focused on performance tuning and high availability, they've placed the new DB platform solely in the MCSE certification..

English English  |  Portuguese Portuguese