Special Offers | My Account | Log In
  0 items in your cart


Search: Boson Sites | Products
Sale Microsoft > MCSA | MCSE > Practice Lab for Microsoft 70-462

Practice Lab for Microsoft 70-462

About This Online Practice Lab:

Exam Numbers: 70-462
Exam Name: Administering Microsoft SQL Server 2012/2014 Databases
Certifications: MCSA, MCSE
Author: Boson
Single-User License  

70-462 Practice Lab

Practice Lab for Microsoft 70-462
See the Lab Videos to learn more.
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 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.

*A Practice Lab purchase includes access for one (1) year from activation.

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
  • Allow you to share labs – great for instructors or students
  • Are accessible through the internet anytime, from anywhere

Microsoft 70-462 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

70-462 Practice Lab 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

See all Microsoft | MCITP | MCSA | Practice Labs | Practice Labs FAQ


Related Products

Marketplace Practice Exam #1 for Microsoft 70-462
ExSim-Max for Microsoft 70-462
Kit for Microsoft 70-462
MCSA: SQL Server 2012 Training
MCSA: SQL 2014 with MCSE: Data Platform Training

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.


MIC-PL-70462-01