Microsoft > MCSA | MCSE > Practice Lab for Microsoft 70-462

Practice Lab for Microsoft 70-462

$99 $49
Exam Numbers
Exam Name
Administering Microsoft SQL Server 2012/2014 Databases

70-462 Practice Lab

The Practice Lab for Microsoft 70-462 provides access* to real computer equipment that is networked together and conveniently accessible over the internet. Practice Labs include multiple pieces of equipment that you can configure. This lab includes instructions that will guide you as you learn the concepts and technologies covered on the Microsoft 70-462 certification exam.
The Microsoft 70-462 certification exam will retire on January 31, 2021.
The 70-462 Practice Lab will provide you with the necessary platform to gain hands-on skills in Microsoft SQL Server 2012 Databases. By completing the lab tasks, you will improve your practical skills in Configure SQL Server Components, Manage SQL Server Agent, Manage and Configure Databases, Configure and Manage SQL Server Instances, Collect and Analyze Troubleshooting Data, Configure and Maintain a Backup Strategy and Manage Database Permissions .
These same tasks will help you understand the objectives and competencies required by the Administering Microsoft SQL Server 2012 Databases certification exam.
See our Practice Labs Youtube Playlist to learn how to purchase, activate and access Boson Practice Labs.
*A Practice Lab purchase includes access for one (1) year from activation.
Practice Lab for Microsoft 70-462
See the Lab Videos to learn more.

Exam Info

The 70-462: Administering Microsoft SQL Server 2012 Databases exam counts as credit toward the following certification(s):
  • MCSA: SQL Server 2012
  • MCSE: Data Platform
  • MCSE: Business Intelligence

Benefits of Online Practice Labs

  • Provide dedicated live equipment without the risk or expense
  • Help improve practical IT skills
  • Can help you learn the knowledge needed to pass the certification exam
  • Are accessible through the internet anytime, from anywhere

Course Modules

Install SQL Server and Related Services

  • Planning SQL Server 2012 Installation
  • Install SQL Server and Related Services
  • Plan for capacity
  • Core mode installation

Implement a Migration Strategy

  • Restore vs. Detach / Attach

Configure Additional SQL Server Components

  • Configure Full-Text Indexing
  • Configure SSIS Security
  • Configure FILESTREAM

Manage SQL Server Agent

  • Create, maintain, and monitor Jobs
  • Automate (setup, maintenance, monitoring) across multiple databases and multiple instances

Manage and Configure Databases

  • Designing multiple filegroups
  • Configuring and standardizing databases
  • Implementing and configuring contained databases

Configure SQL Server Instances

  • Installing default and named instances
  • Configuring server level settings
  • Configuring database mail
  • Configuring SQL Server Engine

Manage SQL Server Instances

  • Installing an instance
  • Managing resource utilization by using Resource Governor

Identify and Resolve Concurrency Problems

  • Examining deadlock issues
  • Creating Alerts on Critical Server Condition
  • Monitoring data and server access

Audit SQL Server Instances

  • Configuring server audits
  • Configuring policy-based management

Manage Logins and Server Roles

  • Configuring server security
  • Managing access to the server, SQL Server instance, and databases

Manage Database Permissions

  • Configuring database security

Troubleshoot Security

  • Managing certificates and keys

Manage Users and Database Roles

  • Managing security roles
  • Creating database user accounts
  • Creating contained logins

Practice Lab for Microsoft 70-462

$99 $49

Be the first to review this product. If you have used this product, you can review it on your account page. You must be logged in to review products.