Advertisements
Home > SQL Server 2012 > Preparing for 70-462 Exam : Administering Microsoft SQL Server 2012 Databases | Certification

Preparing for 70-462 Exam : Administering Microsoft SQL Server 2012 Databases | Certification


I’m from a Database development background and working mostly with T-SQL code only. I passed Exam 70-461 back in Nov-2012, and now I’m planing to give 70-462 Exam i.e. Administering Microsoft SQL Server 2012 Databases.

This exam is intended for Database Administrators who perform:
– Installation
– Maintenance
– Configuration tasks
– and other responsibilities like:
– – setting up Database systems
– – making sure those systems operate efficiently
– – regularly storing, backing up, and securing data from unauthorized access

Thus being a Database Developer (primarily) this exam is going to be the most toughest and trickiest exam in this series as I don’t have DBA experience and haven’t worked on anything in Database Administration yet.

For preparation I’m referring to Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases book.

–> The Exam is divided into 6 modules:
1. Install and Configure
2. Maintain Instances and Databases
3. Optimize and Troubleshoot
4. Manage Data
5. Implement Security
6. Implement High Availability

You need to brush up on following Skills in the these Modules:
-:Check links with the below items for more information:-

1. Install and Configure | 19%
– Plan installation
– Install SQL Server and related services
– Implement a migration strategy
– Configure additional SQL Server components
– Manage SQL Server Agent
– PREP Links: Understanding surface area configuration | Hardware and software requirements for installing SQL Server 2012 | Quick-start installation of SQL Server 2012

2. Maintain Instances and Databases | 17%
– Manage and configure databases
– Configure SQL Server instances
– Implement a SQL Server clustered instance
– Manage SQL Server instances
– PREP Links: ALTER DATABASE file and filegroup options (Transact-SQL) | Contained databases | Data compression

3. Optimize and Troubleshoot | 14%
– Identify and resolve concurrency problems
– Collect and analyze troubleshooting data
– Audit SQL Server instances
– PREP Links: blocked process threshold server configuration option | Configure login auditing (SSMS) | Data collection

4. Manage Data | 19%
– Configure and maintain a back-up strategy
– Restore databases
– Implement and maintain indexes
– Import and export data
– PREP Links: Back up and restore of SQL Server databases | File restores (full recovery mode) | DBCC INDEXDEFRAG (Transact-SQL)

5. Implement Security | 18%
– Manage logins and server roles
– Manage database permissions
– Manage users and database roles
– Troubleshoot security
– PREP Links: Server-level roles | Permissions (database engine) | Database-level roles

6. Implement High Availability | 12%
– Implement AlwaysOn
– Implement Database Mirroring
– HADR (High Availability and Disaster Recovery)
– PREP Links: AlwaysOn Availability Groups (SQL Server) | Microsoft SQL Server AlwaysOn solutions guide for HADR | AlwaysOn architecture guide: Building a HADR solution by using AlwaysOn Availability Groups


-–> You can visit following Study materials to prepare for this Exam:

Microsoft Link for this Certification: http://www.microsoft.com/learning/en-us/exam-70-462.aspx

Book on AMAZON.com: Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases


Will try to update this blog post or will put up a new post with my learning while preparing for this exam.

All The Best!!!

Advertisements
  1. February 27, 2017 at 7:28 pm

    Hi Manoj,

    I passed the 70-461 last week. Your website was very useful for me especially, when I need a summary/tl;dr; version of the concepts that I didn’t quite understand at the time. Thank you for sharing the knowledge.

    Anyhow, have you taken the 70-462 exam at this point? How was it? I just started studying for it over the weekend and found most of the contents to be new realm to me as I spent most of the time on application level rather than server in the past.

    Best regards,

    Patt

  2. Kamalpreet Kaur
    May 26, 2016 at 8:06 pm

    can u make a video on how to set up lab for 70-462? Are u using hyper V or Vmware?

  3. February 3, 2016 at 3:51 pm

    UPDATE on SQL 2014:

    MCSA (461/462/463) exams will be having SQL 2012 content only.

    MCSE (DP: 464/465 and BI: 466/467) exams are updated with SQL 2014 topics. And same will go with 2016 after release.

    ~manoj

  4. January 6, 2016 at 10:30 pm

    I passed 70-461 exam on December 10th.
    I got 816 out of 1000. passing mark is 700. 43 questions 15 query writing, MCQ 20 , matching 5 , multiple check-box 3 may be.

  5. nmb225
    July 1, 2015 at 5:12 pm

    Hi Manoj,
    Have you taken this exam yet? I just passed 461 on Monday and wanted to say thanks for being a great resource. I started reviewing for this exam and want to take it before EOMONTH().. That’s not funny, sorry. I know you’re against the dump practice questions but I gotta say, even though the answers are often inaccurate, the format most closely resembles the actual exam questions which was very helpful on 461

    • July 1, 2015 at 5:20 pm

      Hey, thanks for your comments and appreciate that my post on 70-461 helped you. Yes, I discourage people to use dumps.
      I’m always thinking to give this 70-462 exam, but keep on delaying it, may be I’m not prepared yet 🙂

  6. Leon
    May 13, 2015 at 9:19 pm

    Keep up the good work! Your previous post on Exam 70-461 helped me a lot!

  1. May 1, 2015 at 8:11 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: