subject: Reference Manual For 70-462 Exam [print this page] 70-462 exam is also recognized as Administering Microsoft SQL Server 2012 Databases exam. It is a bona fide credential offered by Microsoft Certification Program. This exam is associated with the following Microsoft Certifications.
(MCSA) Microsoft Certified Solutions Associate SQL Server 2012
(MCSE) Microsoft Certified Solutions Expert Data Platform
(MCSE) Microsoft Certified Solution Expert Business Intelligence
Concepts and Objectives
Main objectives for this exam are to provide knowledge complicated task of administration of associated databases with Microsoft SQL Server 2012.
Associated Product Tested
Following product will be tested but is not limited.
SQL Server 2012
Ideal Aspirants
This exam is specially targeted towards the individuals who are working in the area of installation, configuration and administration of databases system in an enterprise environment.
Recommended and Required Aptitude
It is strongly recommended that candidate must have at least a year of working experience in related field prior to attempt the exam. Candidate should also possess skills and expertise in the following tasks.
How to audit instances of SQL Server
How to back up databases
Effective configuration of additional components of SQL Server
Configuration of services associated with SQL Server
Deployment of migration strategies
Successful implementation of column store indexes
Proper implementation of contained databases
Correct implementation HADR solution (High Availability and Disaster Recovery solution)
How to import and export data
Proper installation SQL Server and related services
Apt maintenance of a database
Apt maintenance of indexes
Management and optimization of databases
Supervision of data partitions
Administration of permissions for database
Administration of database snapshots
Management of logins including management of server roles
Management of SQL Server Agent alerts
Administration of SQL Server Agent jobs
Administration of SQL Server Agent operators
Keen Supervision of SQL Server instances
Keen Supervision of users and database roles
How to Manage log files including creation and designing of log files
Effective optimization of queries
Appropriate installation of plan
Restoration of databases
Proper security troubleshooting
70-462 Course Outline
Microsoft learning has a list of detailed Course outline available at its website. Please visit Microsoft Learning for detailed list and exact blue print of the exam topics.
Questionnaire and Scoring
Questions are multiple options requiring a single response or multiple choices requiring multiple replies. Exam is approximately one hundred and ten minutes long. Candidate securing Seventy percent or higher marks are considered as pass.
Languages Available
This exam is available in eight different languages. Languages are English, French, German, Japanese, Russian, Spanish, Portuguese (Brazil), and Chinese (Simplified).
Registration Process
It is a proctored exam and registration is available at Prometric Testing Center.
70-462 Preparation Tips
Following courses and preparatory stuff is offered and recommended by Microsoft for the preparation of this exam.
Trainer led Classroom course
Course number 10775A
Course Title Administering Microsoft SQL Server 2012 Databases
Course Duration 5 days
Check with Microsoft Learning for scheduling and classing.
