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!!!
Leave a Reply
Current Visitors
StatCounter …since April 2012
Leisure blog: Creek & Trails
- An error has occurred; the feed is probably down. Try again later.
SQL with Manoj 
Keep up the good work! Your previous post on Exam 70-461 helped me a lot!
thanks @Leon 🙂
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
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 🙂
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.
UPDATE on SQL 2014:
~manoj
can u make a video on how to set up lab for 70-462? Are u using hyper V or Vmware?
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
Want to pass 70-462 exam in your first attempt? Then support your learning and preparation with Pass4surekey 70-462 dumps and 70-462 Questions Answers. Your 70-462 exam success is guaranteed with our 100% money back guarantee. Pass4surekey has all updated 70-462 braindumps and 70-462 exam Questions which cover each and every topic of your exam syllabus. For more information just visit the
Website today. https://www.pass4surekey.com/exam/70-743.html