Top Ad unit 728 × 90

Administering Microsoft SQL Server 2012 Databases

Administering Microsoft SQL Server 2012 Databases (70-462) is a required exam for Microsoft Certified Solutions Associate which is a stepping stone for higher level certification from Microsoft such as MCSE Business Intelligence and MCSE Data Platform.

Microsoft has not updated this exam to reflect changes from SQL Server 2014, and the company has no plan to do so anytime soon.

Here is the official statement from Microsoft on the topic:

  • SQL Server 2014 certifications are offered only at the MCSE level. The new product features focus on performance tuning and high availability and are best suited for the MCSE level. As a result:
  • MCSA: SQL Server 2012 and associated exams (461/462/463) will remain in market without any alterations. No MCSA: SQL Server 2014 credential will be offered.
  • MCSE: Data Platform (464/465) and MCSE: Business Intelligence (466/467) exams have been updated with SQL Server 2014 topics.
The 70-462 exam consists of 50 questions and exam takers are given 120 minutes to finish. There are various types of questions on the exam.  There are simple questions with single correct answer and some others require multiple correct answers.  There are other interactive type of question requiring you to drag and drop items on the screen to match or asked to make correct settings using interactive GUI.

Microsoft offers a free one hour training through its Virtual Academy website which you should take advantage of if planning on taking this exam.  The official training kit by Microsoft is another excellent way to prepare for this exam.

The key knowledge required to pass this exam:

  • Describe core database administration tasks and tools.
  • Install and configure SQL Server 2014.
  • Configure SQL Server databases and storage.
  • Plan and implement a backup strategy.
  • Restore databases from backups.
  • Import and export data.
  • Monitor SQL Server.
  • Trace SQL Server activity.
  • Manage SQL Server security.
  • Audit data access and encrypt data.
  • Perform ongoing database maintenance.
  • Automate SQL Server maintenance with SQL Server Agent Jobs.
  • Configure Database Mail, alerts and notifications.

Administering Microsoft SQL Server 2012 Databases Reviewed by Brandon on Wednesday, September 16, 2015 Rating: 5

No comments:

All Rights Reserved by IT Pro Life © 2014 - 2016
Twitter: @ITPro_Life

Contact Form


Email *

Message *

Powered by Blogger.