70-462-v2
Administering MS SQL Server 2012/2014 Databases(70-462)
Prepare for the MCSA 70-462 exam with the Administering Microsoft SQL Server 2012/2014 Databases course and lab. The lab can be mapped to any course, textbook, or training, therefore, adding value and hands-on components to training. The SQL certification course provides complete coverage of the MCSA 70-462 exam objectives and helps you master the skills required for installing SQL server, implementing migration strategies, configuring SQL server components, managing SQL server, managing, and configuring databases, and more.
- Practice in 60 Hands-On Labs — nothing to install
- 16 Interactive Lessons and 99 topics mapped to the official exam objectives
- 210 Practice Test Questions and 2 Full Length Tests
Intermediate Self-paced · 1 year access
60 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
16Interactive Lessons
99Topics
60LiveLab
210Practice Test Questions
105Flashcards
105Glossary of terms
01 / Skills you'll get
What you will be able to do
Try Free →
No credit card required
The Microsoft MCSA Administering Microsoft SQL Server 2012/2014 Databases certification validates candidates' expertise to administer Microsoft SQL Server. This certification is designed for professionals who perform installation, maintenance, and configuration tasks on various databases. Professionals who are responsible for setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access, can also take this certification.
Target Career Roles
- SQL Server Developer
- SQL Database Administrator
- SQL Server Database Integrator
- SQl Server Database Administrator
- Senior SQl Server Database Administrator
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
16 Interactive Lessons · 99 topics01 Introduction +
02 Planning and Installing SQL Server 9 topics · 1 LiveLab +
- Evaluating Installation Requirements
- Designing Installation of SQL Server
- Installing Extra Features
- Identifying Windows Level Security and Service Level Security
- Benchmarking a Server
- Selecting the Right Hardware
- Testing Connectivity to SQL Server
- Understanding Integration Services
- Summary
1 LiveLab in this lesson — see the labs panel →
03 Implementing a Migration Strategy 6 topics · 5 LiveLab +
- Attaching and Detaching Databases
- Migrating Logins
- Understanding Migrations
- Migrating to New Hardware
- Migrating Data from Other Sources
- Summary
5 LiveLab in this lesson — see the labs panel →
04 Configuring SQL Server Components 8 topics · 5 LiveLab +
- Configuring Analysis Services
- Configuring Reporting Services
- Configuring SharePoint Integration
- Configuring SSIS Security
- Configuring Full-Text Indexing
- Configuring FILESTREAM
- Configuring FileTables
- Summary
5 LiveLab in this lesson — see the labs panel →
05 Managing SQL Server Agent 5 topics · 2 LiveLab +
- Creating a Job using SQL Server Management Studio
- Creating T-SQL Jobs
- Creating and Using Operators
- Creating and Using Alerts
- Summary
2 LiveLab in this lesson — see the labs panel →
06 Managing and Configuring Databases 9 topics · 3 LiveLab +
- Designing Filegroups
- Configuring and Standardizing Databases
- Configuring Contained Databases
- Using Data Compression
- Configuring Transparent Data Encryption
- Partitioning Tables and Indexes
- Managing Log Files
- Using Database Console Commands
- Summary
3 LiveLab in this lesson — see the labs panel →
07 Configuring SQL Server Instances 10 topics · 4 LiveLab +
- Installing Default and Named Instances
- Configuring SQL Server CPU Utilization
- Configuring SQL Server
- Virtualizing SQL Server
- Configuring MSDTC in a Cluster
- Setting a Fixed Amount of Memory
- Setting up Database Mail
- Introducing Fillfactor
- Introducing sp_configure
- Summary
4 LiveLab in this lesson — see the labs panel →
08 Managing SQL Server Instances 7 topics · 1 LiveLab +
- Installing a Cluster
- Removing an Installation
- Monitoring and Managing a SQL Server Cluster
- Patching Strategies for SQL Server
- Managing Resource Utilization using Resource Governor
- Cycling the SQL Server Error Log
- Summary
1 LiveLab in this lesson — see the labs panel →
09 Identifying Concurrency Problems and Troubleshooting Data 10 topics · 5 LiveLab +
- Understanding Locks
- Identifying Blocking
- Detecting and Correcting Deadlocks
- Monitoring via DMV
- Monitoring via SQL Server Profiler
- Monitoring Performance with System Monitor
- Identifying Transactional Replication Problems
- Working with Performance Monitor
- Using SQL Server Data Collector
- Summary
5 LiveLab in this lesson — see the labs panel →
10 Auditing SQL Server Instances 5 topics · 11 LiveLab +
- Implementing a Security Strategy in SQL Server
- Configuring SQL Server Audit
- Tracking Changes in SQL Server
- Introducing Policy-Based Management
- Summary
11 LiveLab in this lesson — see the labs panel →
11 Backing Up and Restoring Databases 5 topics · 3 LiveLab +
- Backing Up a Database
- Backing Up the Environment
- Backing Up System Databases
- Restoring a Database
- Summary
3 LiveLab in this lesson — see the labs panel →
12 Implementing and Maintaining Indexes 5 topics · 6 LiveLab +
- Understanding Indexes
- Implementing Basic Indexes
- Understanding Statistics
- Managing Indexes
- Summary
6 LiveLab in this lesson — see the labs panel →
13 Exporting and Importing Data 4 topics · 2 LiveLab +
- Using bcp
- Using BULK INSERT
- Using SQL Server Integration Services
- Summary
2 LiveLab in this lesson — see the labs panel →
14 Implementing Security 5 topics · 12 LiveLab +
- Understanding SQL Server Roles
- Managing Logins, Users, and Roles
- Understanding Encryption
- Auditing SQL Server Activity
- Summary
12 LiveLab in this lesson — see the labs panel →
15 Clustering and AlwaysOn 6 topics +
- Introducing AlwaysOn Availability Groups
- Deploying AlwaysOn Availability Groups
- Using Availability Groups on Failover Cluster Instances
- Understanding Failover Clustering
- Installing a SQL Server Failover Cluster
- Summary
16 Implementing Replication 5 topics +
- Understanding Replication Architecture
- Understanding Replication Types
- Controlling Replication Behaviour
- Monitoring Replication
- Summary
Hands-On Labs Our edge
60 LiveLabs- Installing SQL Server Integration Services
- Detaching the Database in the GUI
- Attaching the Database in the GUI
- Using the Enable Contained Database Feature
- Migrating a Database to a New Version of SQL Server
- Migrating Data from Other Sources
- Installing SQL Server Analysis Services
- Configuring SharePoint Integration
- Configuring SSIS Security
- Configuring Full-Text Indexing
- Configuring Filestream
- Defining a SQL Server Operator using SSMS
- Defining a SQL Server Operator using Transact-SQL
- Designing Multiple Filegroups
- Configuring and Standardizing Databases
- Implementing Contained Databases
- Configuring CPU and Memory Allocation
- Creating a Database User
- Configuring SQL Server Engine
- Enabling MSDTC in SQL Server 2014
- Managing Resource Utilization Using Resource Governor
- Examining Deadlock Issues
- Monitoring via DMV
- Installing the System Monitor in a Custom MMC
- Gathering Performance Metrics Using Activity Monitor
- Monitoring Data and Server Access
- Enabling C2 Auditing
- Creating a New Server Audit and Configuring a Server Audit Specification
- Tracking Changes in the SQL Server
- Determining Read-Only Properties of the Facets
- Creating Custom Categories for Policies
- Creating the conDatabaseSize Condition
- Creating the conPasswordRules Condition
- Creating the conSurfaceArea Condition
- Creating the polDatabaseSizeScheduled Policy
- Creating the polPasswordRulesPrevent Policy
- Creating the polSurfaceAreaLog Policy
- Managing Backups
- Performing a Differential Backup
- Performing a System Database Backup
- Inspecting the Physical Characteristics of Indexes
- Creating a LastName Nonclustered Index
- Creating a City Nonclustered Index
- Setting a Primary Key
- Creating a Column-Store Index
- Disabling and Enabling Indexes
- Performing Bulk Copy Using the bcp utility
- Exporting Data with the Import/Export Wizard
- Creating a SQL Login
- Configuring Local Password Policies
- Creating a Database Role with SSMS
- Creating a Database User Using T-SQL Commands
- Managing Access to the Server
- Managing Logins and Server Roles
- Managing Certificate Logins
- Configuring Database Security
- Protecting Objects from Being Modified
- Creating a SQL User without Login
- Reviewing Certificates and Keys
- Enabling a SQL Server Audit
Labs run in your browser — nothing to install.
03 / Exam details
Administering MS SQL Server 2012/2014 Databases(70-462) Details
Prepare for the MCSA 70-462 exam with the Administering Microsoft SQL Server 2012/2014 Databases course and lab. The lab can be mapped to any course, textbook, or training, therefore, adding value and hands-on components to training. The SQL certification course provides complete coverage of the MCSA 70-462 exam objectives and helps you master the skills required for installing SQL server, implementing migration strategies, configuring SQL server components, managing SQL server, managing, and configuring databases, and more.
Questions
40-60
(per exam)
Duration
120 minutes
(per exam)
Passing Score
The passing score varies from exam to exam and is provided on the score report.
(scaled score)
Exam Fee
USD 165
(per exam)
Delivered by
Pearson VUE
(in-person or online)
Practice Tests
210 Practice Questions
(mapped to official exam objectives)
Certification
70-462-v2
Microsoft credential
Ready to take the exam?
Add your official 70-462-v2 exam voucher to your order.
Official Voucher · Fast delivery · Retake bundle available
Exam voucher is sold separately and not included with standard course.
04 / FAQs
Questions before you start
What are the prerequisites for this exam?+
There are no technical prerequisites for this certification.
What is the exam registration fee?+
USD 165
Where do I take the exam?+
How many questions are asked in the exam?+
The exam contains 40-60 questions.
What is the duration of the exam?+
120 minutes
What is the passing score?+
The passing score varies from exam to exam and is provided on the score report.
What is the exam's retake policy?+
General Microsoft Certification exam retake policy
- If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam. At that time, candidates can log onto their certification dashboard and reschedule the exam themselves.
- If a candidate does not achieve a passing score the second time, the candidate must wait at least 14 days before retaking the exam a third time.
- A 14-day waiting period is also imposed between the third and fourth attempts and fourth and fifth attempts.
- A candidate may not take a given exam any more than five times per year (12 months). This 12-month period starts from the first attempt. The candidate is eligible to retake the exam 12 months from the date of their first attempt.
- To take a given exam more than five times per year or to have the time between attempts waived, a candidate must have experienced one of the errors listed below and request an exception from Microsoft. Requests should be sent to mlsecure@microsoft.com. These requests must include the following information:
- Candidate ID
- First/Last Name
- Email associated with your Candidate ID
- Exam Registration ID
- Exam Number
- Description of error
- Pearson VUE case number
Exam retake exceptions will be granted for the following reasons:
- Failure due to lab crash
- Failure due to Internet connectivity issues
- Failure due to equipment failure
What is the validity of the certification?+
For life
Where can I find more information about this exam?+
Prepare for Administering MS SQL Server 2012/2014 Databases(70-462)
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 60 LiveLab included
- Certificate of completion
No credit card required